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.
N5233RVranicar Franklin E · Corona Del Mar, CAN5234XZonneveld Case M · Hanford, CAN5235XOrtu Gerard · East Hanover, NJN5238Teague Keith S · East Jordan, MIN5240XPaulson Ricky R · Hudson, WIN5242XMilone Colin B · West Glacier, MTN5243XMcclung Aerial Spraying Inc · Big Springs, NEN5244XFrantz William T · Wasilla, AKN5247XTexas Skies Flight School LLC · Boerne, TXN524BTAndraos Aviation Solutions LLC · Northville, MIN5252XGlick Caleb A · Hillsville, VAN5254XDahl Kevin A · Fargo, NDN525CSPrivitt Bret J · Forest Hill, TXN5261XPetri Howard R · Vincennes, INN5262DAmerican Champion Aircraft Corp · Rochester, WIN5264XTank David M · Cambridge, OHN5265XSwanton Peter K · Willits, CAN5266XKrabbenhoft J F · Amenia, NDN5267XShelden Seth · Palmer, AKN5271XRussell Steven N · Anchorage, AKN5273XToledo Jorge A · Miami, FLN5274XStallings Aircraft Propeller LLC · Wynne, ARN5275XKirschner David R · Mckeesport, PAN5276XSanders Curtis E · Morrison, MON5278XFisher Bryan S · Galveston, TXN5280XHonebein Stacey Allen · Seward, AKN5282XGallentine Gene W · Clayton, KSN5284XJay Heather R · Chico, CAN529LSMcnatt Shaun M · Snohomish, WAN52FSGreseth Harold · Buffalo, MNN52GMSchneider Jeffrey A · Pensacola, FLN52LWN8138l LLC · Metairie, LAN52RRSchneider Aerial Inc · Rugby, NDN531TGBurns Peter J · North River, NYN53311Barksdale Air Racing LLC · Conroe, TXN536CMCherry Hill Aviation Inc · Freetown, INN536MAWilliams Fertilizer Services LLC · Oregon, MON53713Haley Wendell B · Williamson, GAN53718Seals James E · Oxford, ALN53719Allen Scott P · Wellington, NVN53723Garthus Nels · Grafton, WIN53724Hackamore Equipment LLC · Prairie City, SDN53726Bower Jessica L · Oshkosh, WIN53728Stinecipher Wilson C · Wasilla, AKN53730Vance Jason · Lufkin, TXN53735Vermont Flight Academy · South Burlington, VTN53737Diloreto Gregory T · Jupiter, FLN53738G&G Equipment LLC · Wasilla, AKN53744Tango Echo Aero LLC · Holly Lake Ranch, TXN53745Speth Kerry G · Oak Harbor, WA
Back to AD 2000-25-02 R1