AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N3371EWings Over Texas Holdings LLC · Denton, TXN3371FRavens Rebuilders Inc · Ellenboro, WVN3371LAgresti Harold David · Ceres, CAN3371TSale Reported · Sanderson, TXSale reported, pending cancellationN3371YChavers Finley L · Newnan, GAN3372DWings Like Eagles Aviation LLC · Newnan, GAN3372FSwanner Robert Craig II · Water Valley, MSN3372SBmf Services USA LLC · Satellite Beach, FLN3372ULeading Edge Operations LLC · Knoxville, TNN3372VSimmons Robert J · Rising Fawn, GAN3373BManley Steven T · Dallas, TXN3373DCarpenter Marshall Owen · Isanti, MNN3373LHowell Nicholas A · Englewood, CON3373RSkylane N3373r LLC · Rancho Cucamonga, CAN3373SWestern Metal Products LLC · Ellensburg, WAN3373URms Industrial Sales LLC · Neenah, WIN33748Mcgowan Daniel J · Springville, CAN3374DScootair LLC · Alburgh, VTN3374LLewallen William J · Eloy, AZN3374SCcf Ventures Inc · Bangor, MEN3374TLazy Eight LLC · Kalispell, MTN3374UMurphy & Son Construction Inc · Brownsville, VTN3374YRegistered aircraftN3375DQualls Randy J · Claremore, OKN3375FKintner William R · Port Angeles, WAN3375LRowan William · New Fairfield, CTN3375RRoyellair LLC · Stone Mountain, GAN3375SN1811 LLC · Aurora, ORN3376DHammond James F · Yellow Springs, OHN3376EFresh Air LLC · Camarillo, CAN3376GLindsay Aviation Inc · West Seneca, NYN3376RStumm Robert W · Cadott, WIN3376VHill Craig · Memphis, TNN3376YFly Greater Breezewood LLC · Clearville, PAN3377JGriffith Scott · Hewitt, TXN3377QMendez Jr Leo · Corpus Christi, TXN3377RLonestar Aeronautics LLC · Paige, TXN3377VGardner Terrence L · Pittsboro, NCN3378CWaples Charles Andrew · Red Lodge, MTN3378EVisalia Flyers LLC · Visalia, CAN3378SM Mercer Livestock Transportation LLC · Hyattville, WYN3378UJeppson Edward M · Nephi, UTN3379UJames Mccullough · Hempstead, TXN337AFKinetic Concepts LLC · Pensacola, FLN337BMorris Robert D · Laughlin, NVN337BBLewis University · Romeoville, ILN337BDSouthern Aircraft Consultancy Inc Trustee · Casper, WYN337BNDestiny Center Inc · Murfreesboro, TNN337BTKrall Jeff · Mitchell, SDN337CBarney Julius C · Lutz, FL
Back to AD 97-01-13