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.
N724RTBrown Robert · Wayne, OKN724SPCandace A Larned Enterprises Inc · Long Beach, CAN724TMiller Neil · Plymouth, MNN724TJPellow James A · Dixie, WAN724TMMorcom Aviation Services Inc DBA · Everett, WAN724TXStratus Aviation LLC DBA · Vacaville, CAN725Butler Harris K III · Towanda, KSN7250NSimon Jevon · Buckley, WAN7250QSale Reported · Crystal, MNSale reported, pending cancellationN7251AHoward F Bret · Albany, OHN7251EFord Michael G · Doerun, GAN7251MSkoglun Jon E · Cashmere, WAN7251NThornton Chad · Seattle, WAN7251QGarcia Crystal M · Brownsville, ORN7251XCampbell Jennings R Jr · Bell, FLN7252ABarbaro Aaron J · Marcellus, NYN7252GLeaders Flying Service LLC · Clear Lake, MNN7252MFoxglove Melanie Ann · Captain Cook, HIN7252QRobbins Aviation LLC · Scottsbluff, NEN7252SDorris Joseph · Lewisburg, KYN7253GOne Mile LLC · Canton, GAN7253QHarry'S Hawks · Wells, MNN7254AStiffey Jason J · Port Orchard, WAN7254HVevani Aircraft LLC · Miami Gardens, FLN7254MPa Prospect Corp · Columbus, MTN7254NChoice Aviation LLC · Hamilton, MTN7254QRegistration Pending · Phoenix, AZRegistration pendingN7254SNickels Robert D · Fayetteville, TNN72559Welch Paul · Oldsmar, FLN7255ANunziato Anthony J · Tewksbury, MAN7255EValley Pilots Flying Club Inc · Martinez, CAN7255MLdg Aviation LLC · Carefree, AZN7255QSierra Sky Aviation LLC · Kalispell, MTN7256GAvstar Inc · Seattle, WAN7256HChaparral Aviation LLC · Edmond, OKN7256QAustin Ferrel Stephen · West Monroe, LAN7256WRoswall James B · Bristol, TNN7256YGupta Vivek · Shelton, CTN72579Allee Mark J · Gillette, WYN7257AJones William Shane · Griffin, GAN7257EAerospring Leasing LLC · Wasilla, AKN7257MParker Charles B · North Pole, AKN7257NPeterson Winston Roy II · Arbuckle, CAN7257QSmith Henry C III · Essexville, MIN7257SFidalgo Flyers LLC · Anacortes, WAN7257TJet & Rotor Aviation LLC · Sacramento, CAN7257XBuckelew James E · Gulf Breeze, FLN7257ZPrivate Pilot Aircraft Rentals LLC · Sanibel, FLN7258International Air Services Inc Trustee · Carson City, NVN7258ANguyen Anthony V · Keyser, WV
Back to AD 79-10-14 R1