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.
N2613SLow Wing Aviation LLC · Mountain Home, ARN2613UHill Richard W · Salem, ORN2614FWissenbach Richard G · Pinesdale, MTN2614LCharter Flights Caribbean Inc · San Juan, PRN2614QBeyers Donald · Pana, ILN2614RWindh Steven R · Reedley, CAN2614VMorris Daniel J · Bossier City, LAN26156Hyannis Air Service Inc · Hyannis, MAN26159Barnes Jeffrey L · Odessa, TXN2615GHyannis Air Service Inc DBA · Hyannis, MAN2615JBatt Keith P · Fairfield, CAN2615QVenture Air Solutions Inc · Opa Locka, FLN2615RWolf Coy D · Ord, NEN2615ZCalhoon John Charles · Woodinville, WAN2616FNotziger Shawn M · Lilburn, GAN2616QSutton Marshall T · Erick, OKN2617GGandiaga Philip J · Buhl, IDN2617NFlightcentrx LLC · Peachtree City, GAN2617QKerhulas Anthony B · Santa Maria, CAN2617RFener Seth M · Claremont, CAN2617SPlummer Kenneth W · Sullivan, INN2618GEagle Mountain International Church Inc · Newark, TXN2618LFl & J Air Corp · West Orange, NJN2618RMelton Edward A · Glendale, AZN2618SOldham Richard · Quartzsite, AZN2618UOubari Hesham D · Suffolk, VAN2618VPlatz James · Auburn, MEN26195Bradley Mark R · Brush Prairie, WAN2619FHayes Barrett W · Siler City, NCN2619GDodson International Parts Inc · Rantoul, KSFirst renewal noticeN2619JFortier Richard · Chico, CAN2619LAircraft Holding Solutions LLC Trustee · Newark, DEN2619QHoman Edward L · Cincinnati, OHN2619RRickert & Son LLC · Moses Lake, WAN2619UChase Joshua R · Princeton, MNN2619Z4j Air LLC · Cartersville, GAN261ALCkm Aircraft Holdings I LLC · Mandan, NDN261DRSafeflite Aviation LLC · Glenwood, IAN261EMJeffrey Brian Cooper · Poway, CAN261GVBohn Jim A · Mead, WAN261PJFly Pj LLC · New York, NYN261SEGapen Patrice Marie · Cheyenne, WYN261SSScopellite Sebastian · Phoenix, AZN262Run For The Hills LLC · Kalispell, MTN2620FWood Don B · Centerville, UTN2620GBas Part Sales LLC · Greeley, CON2620JBenabdallah Mohamed · Lutz, FLN2620QAkroyd Robert F Jr · Raton, NMN2621CThomas James C · Palm Bay, FLN2621FGallaher Boyd H · Prescott, AZ
Back to AD 97-01-13