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.
N3388YMeeks Peris M · Gardena, CAN3389DRegistered aircraftN3389EBarnfather James D · Sequim, WAN3389UThompson Anthony D Trustee · Rockwall, TXN338BMMorton William · Darby, MTN338CALincoln Skyways Inc · Lincoln, CAN338HCapital Holdings Fund IV LLC · Boca Raton, FLN338LMSisk Stephen A · Greenville, ILN338TLMargolis Michael · Ruskin, FLN3390FRodgers Christian Joseph · Ormond Beach, FLN3390JVandyke Dennis C · Rose Hill, VAN3390TTucker Lon R · East Peoria, ILN3390YHead John T Jr · Port St Joe, FLN3391EOcala Aviation Services Inc · Ocala, FLN3391FKingston Terry D · Irving, TXN3391TCardinal Wings LLC · Middletown, DEN3392DHaszard John R · Ophelia, VAN3393TWilcox Russell J · Salinas, CAN3394DCartledge Charles J · Orrville, OHN3394RCurren Patrick V · Green Bay, WIN3394TPekrul Eric C · Frankfort, MIN3394YNolt Ivan M · Mount Solon, VAN3395DFitzgerald John A Jr · Ester, AKN3395JFly N Style · Parkland, FLN3395RJohnston Osceola Holdings LLC · Dallas Center, IAN3395YTriple J Aviation · East Quogue, NYN3396FThompson Patrick J · Evanston, WYN3396RSimmons Craig · Houston, TXN3396VHarvey Christopher J · Port Leyden, NYN3396YPlane Fun Inc · Lewes, DEN3397FKerns Aaron R · Sullivan, INN3397GPro Aire Cargo & Consulting Inc · Oshkosh, WIN3397JZwerko Sherri · South Plainfield, NJN3397RKcsi Aerial Patrol Inc · Bakersfield, CAN3397SMcrae Richard · Kent, WAN3397TMckinney Adrian R · Mineral Wells, TXN3398QRiebe Grover C Jr · Gwinner, NDN3398YBobbitt Michael · Lamont, OKN3399FVetter T Kevin Trustee · Phoenix, AZN3399LMetz William · Laurel, MTN3399QBaron Aviation Corporation · Broad Run, VAN3399RGleason Joseph P · Knoxville, TNN3399UWorley Dan J · Perris, CAN339CHPitch And Power LLC · Indianapolis, INN339CPHenley Mark L · Emelle, ALN339DGRegistered aircraftN339JCNorman Robert Alan · Zanesville, OHN339MSMile And A Half High LLC · Sarasota, FLN339TAFloatsix Leasing LLC · Lubbock, TXN33ADSouthern Turf Services LLC · West Palm Beach, FL
Back to AD 97-01-13