AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N66CMMadson Jerome R · Goodyear, AZN66CRRazer Chester R · Columbia, ILN66DLIzzard William S · Crescent City, FLN66DSPaulsen Rebecca D · Broken Arrow, OKN66EMichaud Michael A · Winslow, MEN66EBAj Aviation Services LLC · Midland, TXN66EGWashburn Tom · Terrell, TXN66FBJames W Woodward · Sagle, IDN66FDExtra Air LLC · Port Orange, FLN66FTTill Robert B · Cody, WYN66FUGreen Steven D · Underhill, VTN66FWBracilano Robert A · Virginia Beach, VAN66GCBecker Air LLC · Grand Rapids, MIN66GJShamrock Aviation LLC · Seabrook, NHN66GNMoye Brian C · Naples, FLN66GVPearson Robert L IV · Spartanburg, SCN66GZGarabedian John H · Southborough, MAN66HERausch William Donald · Ontario, NYN66HUUzzle Harry L · San Antonio, TXN66HYN66hy LLC · Naples, FLN66JFNaylor Matthew · Canyon Lake, TXN66JHHefner James L · Oro Valley, AZN66JJWilliams Nicholas Indrais · Pickerington, OHN66JMRussman Nicholas S · Farmersville, TXN66JSSisson Jp · Litchfield, ILN66KBNorris Victor H · Bremerton, WAN66KPRegistration Pending · Batesville, TXRegistration pendingN66KYKelcher Randi R · Saint Charles, MON66LKeating Gregory D · Carpenter, SDN66LBHermeling Mark A · Vail, AZN66LGHarpenden Corp · Los Angeles, CAN66LYRapid Fleet II LLC · Carmel, INN66MACp Aviation · Santa Paula, CAN66MGPeeler Dixie L · Sandy, UTFirst renewal noticeN66MMTake Flyt LLC · Eagle Lake, MNN66MNGoebel Michael M · Conroe, TXN66MWWhidden Marion H · Okeechobee, FLN66NDMiller Aircraft Services Inc · Crookston, MNN66PArchangel One LLC · Lewes, DEN66PKMorton Dennis D · La Harpe, ILN66PMMajestic Air LLC · Lowell, MIN66PRPeterjohn Management II LLC · Pound Ridge, NYN66PSSaurenman Edward E · Southampton, NYN66PTRobin194 LLC · Prescott Valley, AZN66RDTiger Air 2 LLC · Atlanta, GAFirst renewal noticeN66RPHedges Aviation Inc · Ronkonkoma, NYN66SEDaubenberger Joseph R · Hood River, ORN66SWAviator 20 LLC · Saint Louis, MON66TKCollins Raymond S · Loomis, CAN66TPAmerican Aviation Aircraft Leasing Inc · El Cajon, CA
Back to AD 81-18-04 R2