AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N5522COswald Ron · Eden Prairie, MNN5522EBauman Raymond Scott · Douglas, WYN5522GCoffroth James R · Jamestown, TNN5522SAmeriflyers Of Texas Inc · Addison, TXN5522XChristiansen Aviation LLC · Wilmington, DEN55231Golf November Aero LLC · Sunnyvale, CAN55234Alien Invaders LLC · Medina, WAN55236Bobnal LLC · Conway, SCN5523GSamadzai Ahmad W · Mount Vernon, ILN5523QDolphin Leasing LLC · Daytona Beach, FLN5523RPlett John · Anaconda, MTN5523SDj Flight Service LLC · Little Falls, MNN5523VDolphin Leasing LLC · Daytona Beach, FLN5523YSimmons Scott · Anchorage, AKN55242Hills Holding · Newark, DEN55246Kadena Aero Club · Apo, APN55250Colorado Aircraft Corp · Watkins, CON55256Notam Aviation LLC · Portage Des Sioux, MON5525TDavis Ronnie L · Okmulgee, OKN5525USheriffs Department · Oakland, CAN55264Ace Aircraft Leasing Inc · Nazareth, PAN5526BDoelger Parker · Norwood, NYN5526JBravo Leasing LLC · Daytona Beach, FLN5526RQualitair LLC Trustee · MichelstadtN5527BAdrenaline Inc · Chambersburg, PAN5527CMetzka Andrew J · Chillicothe, ILN5527GFly Around Alaska LLC · Palmer, AKN5527RSchultz David M · East Gull Lake, MNN55285Aerosim Academy Inc · Sanford, FLN5528AWarden Hutterian Brethren · Warden, WAN5528CBaum Jeffrey C · Sheridan, WYN5528EZook Kevin J · East Waterford, PAN5528GRick Aviation Inc · Newport News, VAN5528RVroom Brian D · Tucson, AZN55291Riverside Flight Academy LLC · Riverside, CAN55292Aerosim Academy Inc · Sanford, FLN55294Heavy Metal Air LLC · Farmingdale, NYN55296Heavy Metal Air LLC · Farmingdale, NYN55297Goodhue LLC · Myrtle Beach, SCN55299Trego/Dugan Aviation Of Grand Island Inc · Grand Island, NEN5529CHaralson Stephen K Trustee · Claremore, OKN5529EKaono Jerry C · Carson, CAN5529GSmoot Jeremy D · Fort Wayne, INN5529NTime 2 Fly LLC · Conroe, TXN5529RCarlson Scott M · Sycamore, ILN5529TCornell James R · Winston Salem, NCN5529ZAerosim Academy Inc · Sanford, FLN552KKing Monte L · Kerrville, TXN552MNMtc Air LLC · Blue Ridge, GAN552NDOdegaard Wings Inc · Kindred, ND
Back to AD 79-10-14 R1