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.

N5233RVranicar Franklin E · Corona Del Mar, CABuilt 1946 · S/N 7AC-6567N5234XZonneveld Case M · Hanford, CABuilt 1969 · S/N 684N5235XOrtu Gerard · East Hanover, NJBuilt 1969 · S/N 698N5238Teague Keith S · East Jordan, MIS/N 701N5240XPaulson Ricky R · Hudson, WIBuilt 1969 · S/N 703N5242XMilone Colin B · West Glacier, MTS/N 182N5243XMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1969 · S/N 186N5244XFrantz William T · Wasilla, AKBuilt 1969 · S/N 184N5247XTexas Skies Flight School LLC · Boerne, TXBuilt 1969 · S/N 183N524BTAndraos Aviation Solutions LLC · Northville, MIS/N 435-99N5252XGlick Caleb A · Hillsville, VABuilt 1969 · S/N 190N5254XDahl Kevin A · Fargo, NDBuilt 1969 · S/N 704N525CSPrivitt Bret J · Forest Hill, TXBuilt 1973 · S/N 270-73N5261XPetri Howard R · Vincennes, INBuilt 1969 · S/N 712N5262DAmerican Champion Aircraft Corp · Rochester, WIS/N 649-2027N5264XTank David M · Cambridge, OHBuilt 1969 · S/N 170N5265XSwanton Peter K · Willits, CABuilt 1969 · S/N 124N5266XKrabbenhoft J F · Amenia, NDBuilt 1969 · S/N 191N5267XShelden Seth · Palmer, AKBuilt 1969 · S/N 192N5271XRussell Steven N · Anchorage, AKBuilt 1969 · S/N 196N5273XToledo Jorge A · Miami, FLBuilt 1969 · S/N 175N5274XStallings Aircraft Propeller LLC · Wynne, ARBuilt 1969 · S/N 176N5275XKirschner David R · Mckeesport, PABuilt 1969 · S/N 177N5276XSanders Curtis E · Morrison, MOBuilt 1969 · S/N 212N5278XFisher Bryan S · Galveston, TXBuilt 1969 · S/N 221N5280XHonebein Stacey Allen · Seward, AKS/N 215N5282XGallentine Gene W · Clayton, KSBuilt 1969 · S/N 216N5284XJay Heather R · Chico, CABuilt 1969 · S/N 218N529LSMcnatt Shaun M · Snohomish, WABuilt 1969 · S/N 727-70N52FSGreseth Harold · Buffalo, MNBuilt 1972 · S/N 426-73N52GMSchneider Jeffrey A · Pensacola, FLBuilt 1973 · S/N 70-73N52LWN8138l LLC · Metairie, LABuilt 1999 · S/N 840-99N52RRSchneider Aerial Inc · Rugby, NDBuilt 1946 · S/N 7AC-4014N531TGBurns Peter J · North River, NYBuilt 1974 · S/N 1082-75N53311Barksdale Air Racing LLC · Conroe, TXS/N 1143-76N536CMCherry Hill Aviation Inc · Freetown, INBuilt 2022 · S/N 1202-2022N536MAWilliams Fertilizer Services LLC · Oregon, MOBuilt 2004 · S/N 1378-2004N53713Haley Wendell B · Williamson, GABuilt 1975 · S/N 531-75N53718Seals James E · Oxford, ALBuilt 1975 · S/N 867-75N53719Allen Scott P · Wellington, NVBuilt 1975 · S/N 858-75N53723Garthus Nels · Grafton, WIS/N 181-75N53724Hackamore Equipment LLC · Prairie City, SDBuilt 1975 · S/N 859-75N53726Bower Jessica L · Oshkosh, WIBuilt 1975 · S/N 532-75N53728Stinecipher Wilson C · Wasilla, AKBuilt 1975 · S/N 860-75N53730Vance Jason · Lufkin, TXBuilt 1975 · S/N 861-75N53735Vermont Flight Academy · South Burlington, VTBuilt 1975 · S/N 534-75N53737Diloreto Gregory T · Jupiter, FLBuilt 1975 · S/N 208-75N53738G&G Equipment LLC · Wasilla, AKBuilt 1975 · S/N 863-75N53744Tango Echo Aero LLC · Holly Lake Ranch, TXBuilt 1975 · S/N 319-75N53745Speth Kerry G · Oak Harbor, WAS/N 1111-75
Back to AD 2000-25-02 R1