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.
N65NURanard Douglas R · Dugger, INN65PHMuetzel Michael P · New Port Richey, FLN65PPAir-Supply Aerial · Philomath, ORN65PTBs Aviation LLC · Portland, ORN65RJAdvantage Flight Training And Services LLC · Warren, ARN65RWPhoenix 65rw LLC · Fayetteville, GAN65SAAkin & Son Inc · Texarkana, TXN65SDBlankenship Royce J · Daytona Beach, FLN65SGMacdonald Gerald C · Oberlin, OHN65SVVold Steven A Trustee · Billings, MTN65TKReally Inc · Orange Park, FLN65TXMitchell David Lamar · Ashdown, ARN65WAWoolse Duane L · Salt Lake City, UTN65WMWilson Thomas L · Texarkana, TXN65WYCoyle Jerry Lee · Prairie Grove, ARN65XXWeidenbaum James M · Boerne, TXN65ZMReinschmidt John S · Lakeway, TXN6600PParker Matthew M · Mesa, AZN6600RDoyles Welding Lc · Phillipsburg, KSN66010Crane William Jr · Somerville, ALN66015Rock Solid Aviation LLC · Lake Charles, LAN66018Executive Aviation LLC · Peoria, AZN6601HCanby Pilots Club Inc · Canby, MNN6601JRobinson John H · Kernersville, NCN6601KAir Force Academy Aero Club · Usaf Academy, CON6601RHolmes Donald R · Carlsbad, CAN6601WAircraft Guaranty Corp Trustee · Oklahoma City, OKN66023Bravo Aero LLC · Concord, NCN66025Suburban Air Corp · Castro Valley, CAN6602DLand Of Liberty LLC · Seminole, FLN6602ERivera Joel · Carolina, PRN6602HOver The Mountain Aviation LLC · Calera, ALN6602JD14 Flight Club Inc · Manteno, ILN6602PBertrand Paxton A · Melbourne, FLN6602RFagundes Farms · Hanford, CAN6602YSouthern Aircraft Consultancy Inc Trustee · Casper, WYN66038Landrum Erik G · Austin, TXN6603JWorkman Karen L · Northfield, MNN6603PHales Kurt A · Washington, UTN66046Palm Beach Flight Training Corp · Lantana, FLN66049Aerosync LLC · Miami, FLN6604EFlyn High Aviation LLC · Boynton Beach, FLN6604FEvolution Air LLC · Huntley, ILN6604PBrookhouser David L · Creighton, NEN6604UMr Dent Inc · Manheim, PAN6604WSedberry Jason A · Kokomo, INN66052Gerot David · Janesville, MNN6605DAlameda Aero Club · Alameda, CAN6605FPurdue Aviation LLC · West Lafayette, INN6605JPatton Janet · Denton, TX
Back to AD 81-18-04 R2