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.
N571SPChristiansen Aviation LLC · Wilmington, DEN571TCPardue Troy W · Downsville, LAN571VHVan Hoy Jeffrey D · Knightstown, INN5720CRegistration Pending · Bellevue, NERegistration pendingN5720EInstall Pro Construction LLC · Henderson, NVN5720TFrost Nathan L · Olympia, WAN5721TSeattle Seaplanes LLC · Seattle, WAN5722BVelasquez Benjamin · Anchorage, AKN5722CNeumann John F · Walden, NYN5722EWinfrey Walter A Trustee · Auburn, CAN5722GSchmitt Rudy · Bulverde, TXN5722RCalhoun Barry R · Richardson, TXN5723AAdamson Steven C · Jonesboro, GAN5723CMid Pacific Aero Services LLC · Wahiawa, HIN5723JMcdonald Larry H · Little River, SCN5723RCoffey Bryan K · Anchorage, AKN5723TColeman David R · Limerick, MEN5724CRegistered aircraftN5724EGroup 59 LLC · Oro Valley, AZN5724GCrnic John F · Kirksville, MON5724JPurdue Aviation LLC · West Lafayette, INN5724RMartindale Bryan T · Springfield, ILN5726BBend Aircraft Rentals LLC · Bend, ORN5726CPurcell Kim L · Placerville, CAN5726THall Edward M · Brainerd, MNN5727EZeitvogel Jeanine · Gulf Shores, ALN5727NQualitair LLC · MicheistadtN5727RBiederman Scott · Pompano Beach, FLN5728AMcgiffen Christine L · Vincennes, INN5728BHawkins Charles A Sr · Chillicothe, OHN5728EThibodeau Thomas J · Honea Path, SCN5729AThomas Scott S · Wytheville, VAN5729ERhoades James W · Little Falls, MNN5729RMarreno Eddie J · Green Cove Springs, FLN5729TConservair Inc · Montgomery, TXN572BWBridgewater State University · Bridgewater, MAN572DHSportsmans Recon LLC · Hartwell, GAN572EEcho Air LLC · Anchorage, AKN572GSickles James D · Caledonia, NYN572JAJ.A. Flight Services LLC · Sugar Grove, ILN572NDAerosim Academy Inc · Sanford, FLN572RJUniversity Of Michigan Flyers Inc · Ann Arbor, MIN572SPOld Friend Air LLC · Junction City, ORN5730AMunson Steven L · Martinsburg, WVN5730JLindley Field Flying School LLC · Greensboro, NCN5731CSmith Michael E · Willits, CAN5731JPaulick Adam J · Deerfield, WIN5731RGoward Steven Lee · Oakley, MIN5731TUhen Instruments Inc · Burlington, WIN5732CHoulton Timbre R · Fairbanks, AK
Back to AD 79-10-14 R1