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.
N84LMSchaefer Bernard C · Fairfield, TXN84LSBrenberger Mark L · Raleigh, NCN84MCOn-Site Mech LLC · Helena, MTN84RJM & G Aircraft Management LLC · Aurora, ORN84SHAb Prop Plane II LLC · Metairie, LAN84SJLabelle Gregory D Trustee · Newbury Park, CAN84TMRealm Group Transport Inc · Las Vegas, NVN84USMcginty Flying Service LLC · Jones, LAN8500GAugust Mark C · Atchison, KSN8500JRiley Alfred E III · Norristown, PAN8500TWhite Taylor D · Gainesville, GAN8501KStephenson Joe D Jr · Sand Springs, OKN8501SWitschger Scott L · Albuquerque, NMN8501UOverbaugh Gary R · Highland, UTN8502BSims Hollow M · Lithonia, GAN8502USmitty 172 LLC · Rockford, MIN8503GPynn David W · Gasport, NYN8503SCub Club Inc · Toddville, IAN8503TKolb Bryan C · Hutto, TXN8503UCropley Alton I · Sitka, AKN8504UDoug & Holly Harmon Inc · Fremont, MIN8505BGreen James S · Slaton, TXN8505JKunz Isaac A · Texarkana, TXN8505SAir Repair Inc · Cleveland, MSN8505USilverman Phillip E Trustee · Fullerton, CAN8505XBerri Edward W Jr · N Fort Myers, FLN8506BTierney Garrett J · Manorville, NYN8506GNighthawk Air Systems Inc · Miami, FLN8506JHorning Richard H · Galion, OHN8506QBell Robert C · Colby, KSN8506TM & C Aviation LLC · Corinth, TXN8506XBugli Zachary J · Stevensville, MTN85074Patriot Pole Aviation LLC · Missouri Valley, IAN8507GCaldera Michael E · Williamsport, PAN8508BCc Motors LLC · Redding, CAN8508JJanssen Willis W · Ault, CON8508S8508s LLC · Yerington, NVN8508TLily Gold LLC · Wilmington, DEN8508UEspinosa Isaac · Kissimmee, FLN8509BLafleur Joel A · Garden Valley, IDN8509GVictory Family Church Of Decatur Tx Inc · Decatur, TXN850DRMooers Michael T · Haggerstown, MDN850FGMustang Sally Aviation LLC · Camden, SCN850MGHuston Joe L · Wasilla, AKN850SPAviolease LLC · Vancouver, WAN850WBMorris John A · Phoenix, AZN850YDudley Benjamin H · Wasilla, AKN8510SBarton Andrew · Morehead City, NCN8510UTds Property Holdings LLC · Gilmer, TXN8511TAcute Holdings LLC · Jenks, OK
Back to AD 79-10-14 R1