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.
N6196GFirst Air Service LLC · Show Low, AZN6196JArcher Aviation LLC · Jesup, IAN6196LFiala Frederick P · Kingwood, TXN6196PChristiansen Aviation LLC · Wilmington, DEN6196VRegistered aircraftN6196WDechaine Anthony L · Wyoming, MNN6196ZH&H Ag-Aviation Inc · New Underwood, SDN6197Nixon David W · Waverly, KYFirst renewal noticeN61971Bayport Alumni Recreational Flyers LLC · Shirley, NYN61972Smtm Holdings Inc · Wilmington, DEN61973School Data Solutions Inc · Spokane, WAN61974Proclaim Aviation Ministries · Worthington, MNN61975Fern Sky LLC · Monroe Township, NJN61977Rdr Racing Inc · Latta, SCN61979Maciak Michael · Center Conway, NHN6197JN6197j LLC · Dallas, TXN6197LRanger Airfield Foundation · Ranger, TXN6197PMclain James I · Bokeelia, FLN6197ZClermont Management Services Inc · Marietta, GAN61982Airwatch LLC · Santa Rosa, CAN61985Wiltshire Henry C Jr · Plymouth, MAN6198FFox Aviation LLC · Glencoe, ALN6198MPapa Bear Adventures Inc · Bethel, AKN6198NChristiansen Aviation LLC · Wilmington, DEN6198WCherry Creek School District No 5 · Greenwood Village, CON61990Bauman William O · Abbeville, SCN61991Keime Parker · Show Low, AZN61994Mohawk Flying Club Inc · Ada, MIN6199BD & S Aviation LLC · Spring, TXN6199JReece Donald E · Odessa, FLN6199LBoddy Derrick M · Aiken, SCN6199XH&S Aviation LLC · Chesapeake, VAN619ABAvenge Holdings LLC · Ashburn, VAN619AGUnited States Air Force · Colorado Springs, CON619BGRegistered aircraftN619BLPacific Fleet Aviation LLC · Rochester, NYN619CCDarkhorse Aerospace Holdings LLC · Tampa, FLN619CTCoast Flight Training And Management Inc · San Diego, CAN619EREmbry-Riddle Aeronautical University · Prescott, AZN619FTParsley Thomas B · Downingtown, PAN619JSHeintz Ludwig C · Covington, LAN619KADavidson Dion · Sandy, UTN619MBAirkit LLC · Danville, INN619MWMw Price Corp · San Diego, CAN619NDUniversity Of North Dakota · Grand Forks, NDN619NTCahill Richard J · Columbus, OHN619RBNovember Alpha LLC · Dover, DEN619SCSpartan Education LLC · Tulsa, OKN619SPJet Air Inc · Iowa City, IAN619THAce Aviators LLC · Logan, UT
Back to AD 81-18-04 R2