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.
N319DDenimarck Vincent · Wildwood, FLN319JFRegistration Pending · Johns Island, SCRegistration pendingN319JPElon Aviation LLC · Burlington, NCN319MTSimply Living LLC · Fort Myers, FLN319TATextron Aviation Inc · Wichita, KSN31ACTango Thirty Aero Clube Inc · Mckinney, TXN31AJ1 Alpha Jadzia LLC · Fort Worth, TXN31AWRestoration Dental · Chesterfield, MON31AZDelgado Tony · Denair, CAN31BBohon Todd R · Palmer, AKN31BJAvco Patrol LLC · Lyndon, KSN31CLg & Gs Holdings LLC · Middletown, DEN31CNSkyland Aviation LLC · Alpine, CAN31CULovaas Jean H Trustee · Crescent City, CAN31DDDavis David C · Queen Creek, AZN31EREmbry Riddle Aeronautical Univ Inc · Prescott, AZN31FCInternational Air Services Inc Trustee · Carson City, NVN31FR31fr LLC · Bigfork, MTN31GKMartin Richard B · Corona Del Mar, CAN31JBLucian Aviation LLC · Modesto, CAN31KCWashington State Community College · Spokane, WAN31KDChinook Fibre LLC · Wilmington, DEN31KEWilcox John B · South Charleston, WVN31KGMidwest Corporate Air Inc · Bellefontaine, OHN31KSPaxton Jacob · Killeen, TXN31KTSmith Kenneth L · Pomona, CAN31LDGustte Phil · North Fort Myers, FLN31MDKarmy Paul Edward · Burleson, TXN31MMPence Air LLC · Edinburg, VAN31MRAllred Don J · Wellington, TXN31PGPlacette Jim · Houston, TXN31RTPapuchin LLC · Highwood, ILN31RWSpot Air LLC · Burlington, TXN31SASouthern Airways Pacific LLC · Addison, TXN31SRIsaac Timothy S · Independence, ORN31VRGlaze Roy J · Smyrna, TNN31WDWestern Dakota Holding Co · Timber Lake, SDN31WTThomas Norman W · Forest, VAN31YBProgressive Air Inc · Janesville, WIN31YKJendair LLC · New York, NYN31ZWestern Skymasters LLC · Salt Lake City, UTN32009Ecliax LLC · Craig, AKN3200ERegistration Pending · Burlington, WIRegistration pendingN3200JOdell Steven P · Perrysburg, OHN3200SGreene James · Georgetown, TXN3200UAnderson & Assoc Attorneys At Law Pc · Virginia Beach, VAN3200YCondo Gerardo B · Miami, FLN3201DMelnick Victor D · Mount Bethel, PAN3201SBoder Eric T · Knoxville, TNN3201XSale Reported · Glen Allen, VASale reported
Back to AD 97-01-13