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.
N337CACendejas Christian · Montclair, CAN337CDKeller Stephen P · Wichita, KSN337CEBeam David M · Sabina, OHN337CGH&J Flight One LLC · Sun City West, AZN337CHAviation Specialty Services LLC · Beaufort, NCN337DTomalar Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedN337DEAirbermz LLC · Bloomfield Hills, MIN337DMMcwhorter Michael S · Fortuna, CAN337DWR And R Aircraft Inc · Delray Beach, FLN337EEAmpaire Inc · Long Beach, CAN337EWWilson Cecil · Lithonia, GAN337EXTrepanier Dennis A · Agua Dulce, CAN337FRomain Dennis · Payson, AZN337FTMclenaghan Alvin N · Phoenix, AZN337GDPorrima Photonix Inc · Las Cruces, NMN337GFLewis John P · Alachua, FLN337GGInterventional Cardiovascular Group Of San Juan In · Laredo, TXN337GHInternational Air Services Inc Trustee · Carson City, NVN337GRLor Aviation LLC · Atlanta, GAN337GSJc Holding LLC · Wilmington, DEN337HBCessna 337 LLC · Wilmington, DEN337JFBeaty Andrew R Jr · Wichita Falls, TXFirst renewal noticeN337JJJodice Timothy · Amherst, NHN337JLDavis Mike D · Huntersville, NCN337JRInternational Air Services Inc Trustee · Carson City, NVN337JSI V S K LLC · Wilmington, DEN337KMAltamont Air LLC · Dublin, CAN337LASturgeon Kenneth V · Winter Garden, FLN337LFA To B Flying Inc · Litchfield, ILFirst renewal noticeN337LPSkymaster Stc LLC · Mena, ARN337MMAugugliaro Robert J · Albuquerque, NMN337MWMtw Aerospace Inc · Montgomery, ALN337NEAviation Specialty Services LLC · Beaufort, NCN337PHayes James J · San Diego, CAN337PCPhantom Technologies LLC · Garden City, IDN337PLMaglaughlin Ronald D · Udall, KSFirst renewal noticeN337RTillman Tracy S · Webberville, MIN337RCN337rc Corp Trustee · Wilmington, DEN337RDDamschroder Rex A · Fremont, OHN337RGStephens Kenneth Joe · Bristol, TNN337RRLara Oscar · Bonita, CAN337RSDinwiddie Michael R · Sunbury, OHN337RTTorres Ramon A · Mulberry, FLN337RWRamey Chris M · Simpsonville, KYN337SMFlippin Birds Aircraft LLC · Miami, FLN337SSState Of Wisconsin/Doa · Madison, WIN337SVLillie Ronald G · Salt Lake City, UTN337TGSafe & Sound LLC · Kalispell, MTN337TKSouthern Aircraft Consultancy Inc Trustee · Casper, WYN337TLInternational Air Services Inc Trustee · Carson City, NV
Back to AD 97-01-13