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.
N2563ZWien Richard A · Fairbanks, AKN2564GGarrison Jeffrey R · Clemson, SCN2564RBusse William J · Twin Lakes, WIN2564UBurris Bruce · Deer Park, WAN2564VMay Matthew J · Weatherford, TXN2564YBrewer George H · Muskegon, MIN2564ZDownwind Aviation LLC · Kodiak, AKN2565GMoore Timothy L · Wendell, IDN2565JRohl Bradley S · Thompson, OHN2565RSanders David D · Alvin, TXN2566RRastetter Harold · Douglaston, NYN2566YAns Aircraft LLC · Midland, TXN2567GSunrise Exploration Inc · Northport, WAN2567KBryant Kenneth D · Black Diamond, WAN2567RGone Flying LLC · Loveland, OHN2567URegistration Pending · Fort Worth, TXRegistration pendingN2567VHarness Ben · Covelo, CAFirst renewal noticeN2568GKoechen Wayne L · Cooper Landing, AKN2568ULuce Mark E · Tucson, AZN2569JMapes Peter B · Oscoda, MIN2569KHarris Curtis M · Anchorage, AKN2569SMatanane Roke C · Barrigada, GUN2569UHalladay Roy · Erie, CON2569ZEitilt Aviation LLC · Parker, CON256CAHyannis Air Service Inc · Hyannis, MAN256MWLease Air LLC · Moab, UTN256NYAlexander David H · Warrensburg, NYN256RPAfrica Inland Mission International Inc · Peachtree City, GAN256SAAirview Inc · Ligonier, PAN256SJSan Juan Aviation LLC · Wilmington, DEN256TETimberline Excuvation Inc · Fairbanks, AKN2570JKnutson Family Ltd Partnership 2 · Chetek, WIN2570LHerman John K Jr · Flagler, CON2570QGolden Thomas J · Bishop, GAN2570RSkyblazers LLC · Boones Mill, VAN2570ZLucci Robert J · Long Lake, NYN2571GGolf Air LLC · Anchorage, AKN2571JWullner Leeroy J · Cedar Rapids, IAN2571LClements Jim L · Cushing, OKN25722Mitchell Brian J · Boise, IDN2572GMorgan Nathan · Boise, IDN2572LBuick Robin B · Redding, CAN2572RMladejovsky Michael G Trustee · Paulden, AZN2572SGwin Bryan · La Porte, TXN2572VJarvis Michael Lynn · Orem, UTN2573KDonham Sonjia F · Portland, ORN2573QJayviation Inc · Lake City, FLN2573VOldfield Raymond M Jr · Waupaca, WIN2573YFritz David C · Lincoln, NEN2574RChauvin Junius · Franklin, LA
Back to AD 97-01-13