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.
N8839YMcguinness William V IV · Houston, TXN883ACPlane Fun Inc Tr Trustee · Snellville, GAN883ATDot Aviation LLC · Wilmington, DEN883CFolkers Daniel E · Norwalk, IAN883CGBrock Gary G · Roseboro, NCN883CPCivil Air Patrol · Maxwell Afb, ALN883DFAerial Ag Services LLC · Hillsboro, TXN883EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN883JJJaffe Jordan E · Horseshoe Bay, TXN883MMoffett James D · North East, MDN883RVMann Allen W Trustee · Post Falls, IDN883TCCoughlin Brian T · Cazenovia, NYN883TTRoser John E · Lake St Louis, MON88401Kimball Clayton Scott · Richland, WAN88405Mulhern Georgia · Waddell, AZN88408Steel Mimi · Caldwell, IDN8840FPinchorski Ronald G · Wiconisco, PAN8840NBouillon Gloria J · Somerville, MAN8840WLee Ronald A · Bend, ORN88412Rider Shawna · Anchorage, AKN88417Alaska Department Of Fish And Game · Fairbanks, AKN8841JE & G Flying Club LLC · Alliance, OHN8841WRegistration Pending · Dilley, TXRegistration pendingN8841YHoffman Avery E · Bethel, AKN88421Dular Emil M · Elizabethtown, KYN88424Iowa Aerial Advertising LLC · Perry, IAN88425Klamar Spraying Inc · Gatzke, MNN88428Mason Fred B · Waterford, OHN8842CTerry Jay F · Rome City, INN8842DVan Bergeyk Ronald J · Trapper Creek, AKN8842JCrowe Steven A · Bend, ORN8842WMott Terry W · Hampton, IAN8842YQuest Aviation Inc · Houlton, MEN88437Vst Aviation LLC · Ball Ground, GAN8843JDiorio Christopher J · Melba, IDN8843LPolries Larry J · Jamestown, NDN8843WDay Eric N · Weatherford, TXN8843YBw Aviation LLC · Wilmington, DEN88443Jkt LLC · Douglas, WYN88446Gall Peter D · Morgantown, WVN8844JCave Anthony B · Round Rock, TXN8844NBruegmann Fred R III · Northfield, ILN8844YStreater Aviation LLC · Weirsdale, FLN8845Rudloff Uwe K · Lake Village, INN88451Williams Charles S · Pearland, TXN88453Tribfelner Lance J · St Charles, MIN88458Cole John R · Greenfield, INN88459Carnevale Victor N · Fayetteville, NCN8845FDowning Darrell W · Drakesville, IAN8845JWilliams Daniel · Wallingford, KY
Back to AD 81-18-04 R2