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.
N5481PJohnson Ronald I · Fredonia, AZN5481SPlumb Ray A · Salida, CON5481WBawden Frederick M · Brookfield, WIN5481ZDicenzo Eugene N · Cumberland, RIFirst renewal noticeN54829Aviate LLC DBA · Hazelton, IDN5482GBorne Shaun M · South Rockwood, MIN5482LEgli Dru D · Howe, INN54832Maskityj LLC · Hagerstown, MDN54838Draco Flight School DBA · Chino, CAN5483HKriner Steven J · Billings, MTN5483KIzzo Michael D · Phoenix, AZN5483LLawton George F · Auburn, CAN54844Dynasty Adventure Inc · Mentone, CAN54849Colorado Northwestern Community College · Rangely, CON5484DAerobiz LLC · Lewes, DEN5484LAugustine Robert J · The Villages, FLN5484PRussi Kenton S · Caldwell, IDN54851Metz William H · Laurel, MTN54855Christiansen Aviation LLC · Wilmington, DEN5485HGiron Lawrence · Anchorage, AKN5485KBarr Air Patrol LLC · Mesquite, TXN5485LBeaudry Charles F · Graham, NCN5485MN446rh LLC · Helena, MTN5485PGoodlin Scott · Tulare, CAFirst renewal noticeN5486DFord Bernard DBA · Sidney, NYN5486HWhisonant Robert J · Winnett, MTN5486LStelly Christopher · Houston, TXN5486NTorgerson Roald L · Lewistown, MTN5486PHorton James D · Las Vegas, NVN5486SPlane Fun Inc Tr Trustee · Snellville, GAN5487Rhj Investments LLC · Show Low, AZN5487BPotcake Aviation LLC · Missoula, MTN5487FKettlehut Alan W · Ceresco, NEN5487KRingen Marvin O · Beaverton, ORN5487LLaw C Scott · Oklahoma City, OKN5487PDotterer Kurt Samuel · Bloomfield, IAN54881Huntsville Soaring Club · Brownsboro, ALN5488MPerson Michael · West Chester, PAN5488PScheuermann Hugo T · Cape Coral, FLN5488SJanssen Paul · New Castle, INN5488TWestphal Ronald R · Aurora, ILN5488ZLand Cecil J · Goshen, KYN54898Central Indiana Soaring Society · Yorktown, INN5489HMcmahan Charles B · Gakona, AKN5489LRib Runner LLC · Sioux Falls, SDN5489PClarke Adam M · Lompoc, CAN548ASouthern Illinois University · Murphysboro, ILN548CLSpielmann Thomas G · Aurora, INN548CWCentral Washington University · Ellensburg, WAN548DGorowsky Craig · Tucson, AZ
Back to AD 81-18-04 R2