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.
N7264ABridge Creek Logging Inc · Mount Vernon, ORN7264DGravity & Grace LLC · Mill Valley, CAN7264NSelect Equipment Inc · Kokomo, INN7264QAdams Rick B · Ashford, WAN72653Atp Aircraft 2 LLC · Wilmington, DEN72658Tidewater Flying Club Inc · Newport News, VAN7265BHolladay Aviation LLC · Jacksonville, FLN7265NSkylane Bicentennial LLC · Waynesboro, VAN7265SRiver City Flying Club Inc · Sacramento, CAN7265TKor Aviation LLC · Piedmont, SDN7265YAv8r LLC · Manchester Center, VTN7265ZAtp Aircraft 2 LLC · Wilmington, DEN72662Jwa Flight School LLC · Bolingbrook, ILN72664Advanced Aviation Group LLC · Frederick, MDN72667Rro Leasing LLC · Grand Forks, NDN72669Mid-Island Air Service Inc · Ronkonkoma, NYN7266ABrooks David A · East Dorset, VTN7266DMelbourne Flight Training LLC · Melbourne, FLN7266MFerrarer Joseph H Trustee · Glendora, CAN7266NBeck Robert A · Cove, ORN7266QLima-001 LLC · Muscatine, IAN7266SRush William A Trustee · Boulder Creek, CAFirst renewal noticeN7266TNobles Gary Allen · Winnsboro, LAN7266YAvero Aviation LLC · Dover, DEN7266ZBearing Tree Land Surveying LLC · Oklahoma City, OKN72671Vfr Aircraft And Training LLC · Jackson, MON72675Chapel Hill Flying Club Inc DBA · Sanford, NCN7267EHigh Range Aviation Inc · Gooding, IDN7267GWells Jack D · Newtown, MON7267MLeasa Marc · Fond Du Lac, WIN7267NSwalling John C · Anchorage, AKN7267TDmcc LLC · Lewes, DEN7267XJudge Eli A · Whitefish, MTN7267YVolatilis Aviation LLC · Collinsville, ILN7267ZHoffpauir Jeremy · Broussard, LAN72689Brown Nathan · Snellville, GAN7268EBoyer Steven L · Wooster, OHN7268FFarber Gerald · Las Cruces, NMN7268GSteel & Supply Co LLC · Pensacola, FLN7268KFelts Field Flying Club · Spokane Valley, WAN7268TParker Harold E · Cabot, ARFirst renewal noticeN72692Mccurdy Dwight B · Anderson, INN7269416 Sandals LLC · Tuscaloosa, ALN72697Cbt Aviation LLC · Bellingham, WAN7269BReece Vance · Winnsboro, TXN7269EFerguson Douglas M · Mount Vernon, ORN7269GBranson Barry R · Shasta Lake, CAN7269NAk Air Leasing LLC · Homer, AKN7269QBaker Mark · White Bear Lake, MNN726AJStarr Alan D · Senoia, GA
Back to AD 79-10-14 R1