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.
N85VBRegistered aircraftN85XYWilliams Jerome L · Forkland, ALN8600BGold Daniel A · North Pole, AKN8600GHunter Brian D · Scranton, IAFirst renewal noticeN8600UCristiano Thomas J · Clifton Park, NYN8600ZChamberlin Aviation · East Wenatchee, WAN8601BKorta Stephen E · Poplar Grove, ILN8601GRamakrishna Murali DBA · Burlington, MAN8601SDykstra Wayne A · Pipestone, MNN8601TSmalley Roger A · Medford, ORN8601UKing Stephen M · Trout Lake, WAN8601ZMagnolia Springs Properties Inc · Kirbyville, TXN86020Yamnik Alexander E · Glencoe, MNN8602BShannon Terrence M · Kuna, IDN8602TReed James E · Inverness, MSN8602UAllegood Jerry C · Moultrie, GAN8603BBrown Benjamin J · Kasilof, AKN8603TBaldwin Glen R · Culdesac, IDN8603XShelton Michael E · Patrick Springs, VAN8604BPlesich Nicholas J · Point Roberts, WAFirst renewal noticeN8604JPouncey Wayne · Merced, CAFirst renewal noticeN8604TAircrafters LLC · Tucson, AZN8604UMurray Stephen A · Worthington, OHN8604ZHirsch T J Jr · Olney, TXN8605GPhelps John W · Spring Hill, FLN8605UTurner Scott K · Wichita Falls, TXN8606BShayne Mark S · Arlington, WAN8606JMaedgen Gary W · Voss, TXN8606SFlight Time Builders Inc · Memphis, TNN8606THh Leasing Corp · Jacksonville, FLN8606UJones Roderick W Trustee · Thomas, OKN86071Mccumber Peter W · Sorrento, FLN8607GShooting Star Museum · Devine, TXN8607TLynden Flying Club Inc · Lynden, WAN8607UAero Dynamics Flying Club Inc · Beavercreek, ORN8607XWilkinson Richard R · Eustis, MEN8608JWalker Rhan E · Pleasant Hill, MON86092Hubler Brian E · Paxinos, PAN8609GCourt Amy L · Staatsburg, NYN8609TSloan David J · Anchorage, AKN8609XWilson J Brent Trustee · Lander, WYN860AATextron Aviation Inc · Wichita, KSN860AUAuburn University · Auburn, ALN860CPChristiansen Aviation LLC · Wilmington, DEN860PARe Elite Aviation LLC · Hialeah, FLN860SASaint Clair Flight Academy Inc · Richmond, MIN860SPRegistered aircraftN860TWSun City Air Charter LLC · Davie, FLN860WBWings Of Blessing · Fort Worth, TXN860XWiebelhaus John J · Strasburg, CO
Back to AD 79-10-14 R1