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.
N816RDHoffman Aeronautics LLC · Sedalia, CON816RFTerhaar Ronald D · Albany, ORN816RMRegistered aircraftN816STForensic Doctors Group Pc · San Francisco, CAN816SWUniversity Of Alaska Anchorage · Anchorage, AKN816TRGood Day Holdings LLC · Sheridan, WYN816TSCd Logic Inc · Wilmington, DEN816TXDavis Derek P · Sebastian, FLN816WAFredericks Ruth · Miami, FLN816WBNorthern Aggregate Inc · Bemidji, MNN816WLRumsey Todd · Sturgis, MIN816WMRent A Copter LLC · Homer Glen, ILN816WRDonovan Mark J DBA · Moultonborough, NHN816YQazwbt LLC · Arroyo Grande, CAN8170CGibbens Brett S · Mc Grath, AKN8170FAlfonso Peter J · Jamestown, RIN8170NFalter George H III · Baltimore, MDN8171Thaven Aviation LLC · Edwards, CON81713Brown Matthew · Spokane, WAN81715Registration Pending · Hanford, CARegistration pendingN8171CPeed Aviation Inc · Casa Grande, AZN8171DLueking Clyde F · Holdrege, NEN8171NOndrovic Rick · Belton, SCN8171YFaith Works Aviation LLC · Glenmoore, PAN8172Magrini Shawn P · Salem, OHN81723Aero Legacy Foundation · Basehor, KSN81729Bushroe Dennis J · Temperance, MIN8172CDrath Mark O · Reedsville, WIN8172NBeasley Michael Jeffrey · Dothan, ALN8172QFrost Aviation Services Inc · Las Cruces, NMN8172WMile High Advertising LLC · Dover, DEN8172YKline John C · Wolcottville, INN8172ZAverka Steven D · Sutton, MAN8173DAaa Flying Service Inc · Wellington, TXN8173ESky Equity LLC · Woodbury, MNN8173HMcmahon Mary G · Winchester, CAN8173NJones Roy F · Benson, AZN8173WRoadrunner Flight School LLC · Farmington, NMN8173YAltitude Aviation Group LLC · Kissimmee, FLN81741Corsican Aviation LLC · Westfield, INN81749Friend Aircare Inc · Washington, PAN8174MFlight Time Builders Inc · Memphis, TNN8174PIglewski Rudolph Daniel II · Apache Junction, AZN8174WJeffers Coreen · Bellmawr, NJN8174XJones Aaron B · Bruceton Mills, WVN8174YStansbury Todd V · Centennial, CON81756Jrny Air LLC · Everett, WAN8175CYates Trucking Inc · Quartz Hill, CAN8175EHigh Planes Aviation LLC · Goodland, KSN8175HHowe Richard B · San Luis Obispo, CA
Back to AD 81-18-04 R2