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.
N5360CJpm Flying Service LLC · Coleman, TXN5360JFly Montana LLC · Miles City, MTN5360RSommer Wayne · Wellsville, MON5360TCurran Ronald J · Olympia, WAN53610Joe Wigginton Leasing LLC · Henderson, NVN53611Aero Mobil Inc · Wilmington, DEN53614Orange County Flight Center Inc · Santa Ana, CAN53617Holloway Walter F · Cocoa, FLN5361BSkydive Ricks LLC · Petersburg, OHN5361DPannone Steven R · Palmer, AKN5361KLong Island Soaring Association · Shirley, NYN5361QBushre David N · Janesville, WIN5361TDick Ronald J · Fort Wayne, INN53620Micren Design LLC · Yorktown, VAN53622Mc Air LLC · Miami Beach, FLN53628Jacks Charles H · Anguilla, MSN5362AFerguson Lynn D · Alpine, WYN5362HMccue Tedd R · Eveleth, MNN5362QHelderman Curtis L · Newton, NCN5362RWeinhold Dale J Trustee · Ellsworth, KSN53630Arlington Flight Services Inc · Arlington, WAN53632Siple Aviation LLC · Kalispell, MTN53636Sterling Flight Training · Jacksonville, FLN5363CAffiliated Equipment Leasing LLC · New Castle, DEN5363KMission Aviation Training Academy · Arlington, WAN5363RCrawford James A · Coshocton, OHN5363ULefore Jeffry Thomas · Milton Freewater, ORN5363ZClover Park Technical College · Lakewood, WAN5364ABradley Flying Association · Peoria, ILFirst renewal noticeN5364BWest James L · Roswell, NMN5364CFischer James E · Lakeville, MNN5364KAir S&T LLC · San Juan Capo, CAFirst renewal noticeN5364TKato Matt J · Fairbanks, AKN5365CKlotz Terrance M · Sparks, NVN5365QWelborn Mark · Boonville, NCN5365SGamm Stephene Wade · Warrenton, VAN5365TLaperle Aviation LLC · Colebrook, NHN53663Iron Shield Aviation LLC · Fort Pierce, FLN5366DHeinrich Rivero Hinze Max · San Antonio, TXN5366JSlipstream Aviation LLC · Calera, ALN5366KAmerican Patrols Inc · Midland, TXN5366SCraig Daniel O · Baytown, TXN5366TTbl Aviation LLC · Springfield, ORN53670E&S Management LLC · Miami, FLN53671Kennedy David C · San Diego, CAN53676N5860a LLC · Catawba, NCN5367CAv8rs LLC · Gig Harbor, WAN5367DBandrowicz Leon A · Shelby, MIN5367HWingsleasing LLC · Wichita, KSN5367QLeatherneck Aviation LLC · Billings, MT
Back to AD 79-10-14 R1