AD 2000-25-02 R1
Registered aircraft · 7,563
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:2000-25-02-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-25-02-R1')
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:2000-25-02-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-25-02-R1') 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.
N7917SNelson Cliff A · Joplin, MTN7918SKnox James P · Park Rapids, MNN791KBLucky Dog Aviation LLC · Victoria, TXN792THbhis LLC · Gnadenhutten, OHN793BPlumhoff Uwe E · La Center, WAN793LLetourneau University · Longview, TXN795ACZorba Chad · Grapevine, TXN795JPLange Daniel C II · Oakland, CAN795LLetourneau University · Longview, TXN796TMBlack John E · Cocoa Beach, FLN797ACWoods Gregory W · Englewood, FLFirst renewal noticeN797LLetourneau University · Longview, TXN797PFBerggren Philip C · Gunnison, CON798LLetourneau University · Longview, TXN798MATobago4 LLC · Lawrenceville, GAN799KMonarch Aviation LLC · Dillon, MTN799LKelley Stephen D · North Easton, MAN799MA406 Mountain Air LLC · Bigfork, MTN799RGRegistration Pending · Dayton, OHRegistration pendingN79ACTen G LLC · Waddell, AZN79KRRedick Albert L II · Reno, NVN79QBBaer Marcus R · Aubrey, TXN79RARegistered aircraftN7DFSkyshoe III LLC · Beverly, MAN7DTPeet Edward V · Lady Lake, FLN7ECWolford Sales & Leasing LLC · Abingdon, ILN7JBB F Service Inc · Bloomington, INN7XPInternational Air Services Inc Trustee · Carson City, NVN7XVPagenkopf Joseph C · Juneau, AKN800PTContner Gary E · Huntsville, OHN8023MWhite Paul M · Elizaville, NYN8038WMctaggart Briar C · Adelanto, CAN80461Bremer Wilfred P · Madison, WIN804JSButler Jack L · Bennington, OKN804SMVogt Gregory A · Broken Arrow, OKN8057HTrevor Bruce B Jr · Green Bay, WIN805ACSouthern Sky LLC · Henderson, NVN805BCCrosswind Landing Inc · Mccall, IDN805STDga Avition LLC · Sacramento, CAN805TTTim Twisselman Enterprises Inc · San Luis Obispo, CAN8060XChance Malcolm · Folsom, CAN806CInternational Divers Co Inc · Corpus Christi, TXN808BWWeber William A · Brodhead, WIN80BDJtr Aviation LLC · Canton, TXN80SDLake Area Technical College · Watertown, SDN80TARegistration Pending · Lancaster, CARegistration pendingN8111NRhinebeck Aerodrome Museum · Rhinebeck, NYN813AXColley Douglas W · Spokane, WAN813KMSantopietro Paul · Dunnellon, FLN81401Sipes Jacob L · Sunbury, OH
Back to AD 2000-25-02 R1