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.
N4715DPetracca Carmine J · Lewiston, IDN4715FRegistration Pending · Ukiah, CARegistration pendingN4715JClarke Brent H · Neversink, NYN4715KSki Town Aviation Management LLC · Steamboat Springs, CON4715XBlair Ross Iain · Milford, NJN4716BClose Keith · Anchorage, AKN4716DDavenport Reginald · Evans, WAN4716KGlobal Acquisition Ltd · Davenport, IAN4716NHolcombe Aaron L · Jay, OKN4716XJessup Sheila · Dublin, CAN4717CCt Aviation LLC · Fort Worth, TXN4717NHaagenson Jeffrey M · Portland, ORN4718BMartin Nathaniel W Trustee · Wasilla, AKN4718DAviation Of North Florida LLC · Jacksonville, FLN4718FPbar Inc · Joseph, ORN4718KMayes John · Carson City, NVN4718NL3harris Technologies Flight Capital LLC · Greenville, TXN4718XRobb James W · Uhrichsville, OHN4719FFrederick Joel · Hobe Sound, FLN4719KOneninekilo LLC · West Linn, ORN471BCHyndman Antonio · Canton, TXN471EREmbry Riddle Aeronautical University · Daytona Beach, FLN471JROrtiz Rivera Jose E · Bayamon, PRN471MRAdvanced Aviation Group LLC · Frederick, MDN471PRRed Arrow Aviation LLC · Santa Teresa, NMN471SPPine Ventures LLC · Malmo, NEN471TMAlf Ix LLC · Chicago, ILN472Custer Charles D · Destin, FLN4720CNesbit Gary M · West Linn, ORN4720KGeorge Joseph Q · Granbury, TXN4720QFielding William J IV · Scarborough, MEN4720RHotkeys Holding LLC · Silver Spring, MDN4720YKraemair Aviation LLC · Sauk City, WIN4721DCarm'S LLC · Beaver Springs, PAN4721NRegistered aircraftN4721QXtreme Attitudes LLC · Sanford, NCN4721RWaterdawg Express LLC · Pocatello, IDN4721UBartlow Amos · North Pole, AKN4722BHill James P · Eagle Point, ORN4722FStoskopf Scott W · El Dorado, KSN4722UBlackmon Peter G · Anchorage, AKN4723FStraightin LLC · Paauilo, HIN4723NNorth Central Aircraft LLC · Blaine, MNN4723RSmolkin Alexander S · North Chesterfield, VAN4723YRegina Air Cargo Corp · Wilmington, DENon-citizen corporation, flight hours not reportedN47249Farnsworth Erwin L · Anchorage, AKN4724BSchlink Richard L · Soulsbyville, CAN4724KWalgrove Venice LLC · Santa Monica, CAN4724QDehart T James Trustee · Kalama, WAN4724XFlying My Dreams LLC · Miami Gardens, FL
Back to AD 79-10-14 R1