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.
N8544DThames James W · Florence, ALN8544LMid Continent Aircraft Corp · Hayti, MON8544NWalton Joseph B · Arlington, TNN8544WTyler Brian W · San Gabriel, CAN8545DFour-Five-Delta LLC · Mountainville, NYN8545NMatheny Robert S Jr · Beaufort, NCN8546NBeaver Brook Aviation LLC · Scotia, NYN8546WNowos Monica Leigh · Rochester Hills, MIN8547Carlson Cory R · Trail, MNN8547ECarpenter Lionel Lee · South Fork, CON8548Collum Aviation LLC · Milton, FLN8548CMapes Peter B · Oscoda, MIN8549Koenig Steven T · Ostrander, OHN8549EDrageset Denvero · Isabel, SDN8549NDowning Ray E III · Topeka, KSN8549PWest Texas Weather Modification Association · San Angelo, TXN8549WAllstead Bradley E · Trenton, MIN854ACKurchian Aram M · Sunland, CAN854AFAmeriflyers Of Texas Inc · Addison, TXN854AKAraki Satoshi · Hayward, CAN854CAJunie The Flying Dog LLC · Atlanta, GAN854CPCivil Air Patrol · Maxwell Afb, ALN854DRDix Mark · Wray, CON854DZHohnadel R Michael · Harlingen, TXN854EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN854GRegistered aircraftN854GWCondair Flyers Inc · Latham, NYN854HCN854hc LLC · Watkinsville, GAN854KMSparrowhawk Aviation LLC · Hollister, CAN854NDAero Equities LLC · Ventura, CAN854PD139th Aeroclub LLC · Miami, FLN854RVRoberts Thomas G · Seattle, WAN854SCAlpha Charlie Aviation LLC · Keizer, ORN854TBBrown Thomas R · Gainesville, FLN854VLBlue Waters Air Charters LLC · San Juan, PRN854WSMn Helicopters Inc · Minneapolis, MNN8550CBig Sky Communication & Cable Inc · Billings, MTN8550DRiester Gary R · Navarre, FLN8550LHigh Desert Soaring Clubinc · Bend, ORN8550UThompson Peter S · New Hampton, NHN8550WRegistration Pending · Nampa, IDRegistration pendingN8551CRautiola Charles A · Rosemount, MNN8551DCordingley Robert L II · Lafayette, CON8551LQuality Avition Inc · Marana, AZN8551NRegistered aircraftN8551VTall Timber Flying Service LLC · Kalispell, MTN8551WDaideo Enterprises LLC · Slingerlands, NYN8552DSvec Adolph Ralph · Marengo, ILN8552LWhittington John H Jr · Dillon, SCN8552VBurkey Dale · Walnut, IL
Back to AD 81-18-04 R2