AD 94-05-05 R1
Registered aircraft · 26,230
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N86361Bias Christopher S · Wasilla, AKN8636BFisher'S Crop Care By Air LLC · Fredericktown, OHN8636UMls Holdings · Newbury Park, CAN8637GReichenbach Louis · Northville, MIN86381Waterman Victoria M · Defuniak Springs, FLN8638SLyon Ronald C · Berlin, VTN8638ULittle Kenneth C · Driggs, IDN8639GRegistered aircraftN863RKN863rk LLC · Grand Bay, ALN8640GRoss Peter W · Lufkin, TXN8640USunnyside Aviation Pllc · Theodosia, MON8641SSimmons Anthony C Jr · Allendale, SCN8641UJohnson Jay A · Lisbon, IAN8642BCommercial National Flooring Inc · New Carlisle, OHN8642UNemerovsky Jason B · Plantation, FLN8644BUavionix Corp · Bigfork, MTN8644GMelin Jeff C · Kenmare, NDN8644SRiggan Charles H · Oxford, NCN8644UFung Tak C · Ridge, NYN8645URocereta Aaron W · Eagle River, AKN8646SFoster Brian E · Bartley, NEN8648GAugust Aero LLC · Kalispell, MTN8648SSnodgrass Gavin I · Belle, MON8649GMullins Steve F · Belews Creek, NCN8649SGuffey Edward B · Bessemer City, NCN864TGTouch N Go Aeroworks LLC · Greenville, SCN86506Harker James P · Forest Lake, MNN8650BKing Kenneth M · Charleston, SCN8650SGrant Clinton A Trustee · Portage Des Sioux, MON8653GArmstrong John K · Lovington, NMN8653UCurtis Heather · Fairbanks, AKN8654UThompson George C · Rogersville, ALN8655BFredrickson Sherman E Jr · Norman, OKN8656CRhodes Charles R · Homosassa, FLN8656JMeyer Eric Trustee · Moscow, IDN8657GClayton Patrick D · Hazen, ARN8657JCompany Air LLC · Bermuda Dunes, CAN8657URidley Timothy A · Uniontown, PAN8658GWestrum Sean Ross · Norwalk, IAN8658SBird Jared N · Mission, TXN8659GCoker Jason John · Caribou, MEN8659JThomas Chase D · White Oak, TXN8659SRegistration Pending · Davenport, FLRegistration pendingN8660BNaramore Tyler R · Salem, MON8660SDepaula Saulo C T · Princeton, MAN8660USage Point Ventures LLC · New Harmony, UTN8661BBottorf Benjamin R · Springfield, ILN8661JSaa Enrique A · Lubbock, TXN8661UBaird Adam D · Salisbury, NCN8662BPark Arthur N · College Park, GA
Back to AD 94-05-05 R1