OpenAirDocs.org
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.

N53975Cox Kelsi J · Williamsburg, IABuilt 1976 · S/N 238-76N53977Bosick Gregg A · Kasilof, AKBuilt 1976 · S/N 921-76N53978Sanborn John M · Wasilla, AKBuilt 1976 · S/N 569-76N53982Pearson Scott A · Tipton, IABuilt 1976 · S/N 239-76N53983Johnson David H · Jasper, GABuilt 1976 · S/N 1157-76N53984Horton Brad L · Lavernia, TXBuilt 1976 · S/N 570-76N53986Flyit LLC · Camas, WABuilt 1976 · S/N 1158-76N53988Jensen Marian D · Auburn, WABuilt 1976 · S/N 1161-76N539GCKor Aviation LLC · Piedmont, SDS/N 11AC-1850N539JJChersky Brian A · Santa Maria, CABuilt 1979 · S/N 1175-79N53CCPcb Air LLC · Wilmington, DEBuilt 1993 · S/N 720-93N53SELundquist Christopher E · Hillsborough, CABuilt 2005 · S/N 1387-2005N540ACChristians Ricky P · Appleton, WIBuilt 1977 · S/N 1206-77N540DYYeager Joseph H · Zionsville, INBuilt 2011 · S/N 1460-2011N541DZLarson Alexis Kae · Bismarck, NDS/N 92N541MERegistered aircraftBuilt 2007 · S/N 1400-2007N543MACorbett Mark K · Oshkosh, WIBuilt 2004 · S/N 972-2004N5442VGilbert David O · Othello, WABuilt 1961 · S/N 7BCM-339N548DGorowsky Craig · Tucson, AZBuilt 1979 · S/N 513-79N548MAKcsi Aerial Patrol Inc · Bakersfield, CABuilt 2006 · S/N 507-2006N5498NFarmer Richard M · Tuscaloosa, ALBuilt 1947 · S/N 7BCM-251N549ACWhitaker James C · Washington, NCBuilt 2001 · S/N 449-2000N549MAHinkle Airspray Inc · Cavalier, NDBuilt 2005 · S/N 1384-2005N5500CDuncan Robert L · Greenville, MSBuilt 1978 · S/N 401-78N5500LWinchell Lawrence R · Salem, NJBuilt 1978 · S/N 1032-78N5500MDecathlon Training Inc · Saint Louis, MOBuilt 1978 · S/N 402-78N5500WKansas State University · Salina, KSBuilt 1978 · S/N 432-78N5501AProfly LLC · Wichita Falls, TXBuilt 1978 · S/N 360-78N5501NRoddy Warren D · Skokie, ILBuilt 1978 · S/N 1034-78N5502AAero Enterprises LLC · Orange, VABuilt 1978 · S/N 408-78N5502CWebb Brad · Ekron, KYBuilt 1978 · S/N 1259-78N5502HSky View LLC · De Smet, SDS/N 1035-78N5502MRegistered aircraftBuilt 1978 · S/N 275-78N5502U90 Degree Crosswind LLC · Arcadia, FLBuilt 1978 · S/N 1260-78N55034Osceola Aerosport LLC · Osceola, WIBuilt 1978 · S/N 420-78N5503AKey Dallas T · Hoover, ALBuilt 1978 · S/N 411-78N5503CMccreary William J · Glendale, AZBuilt 1978 · S/N 412-78N5503HCp Aviation Inc · Santa Paula, CABuilt 1978 · S/N 413-78N5503JFalterman Patrick J · Cleveland, TXBuilt 1978 · S/N 414-78N5503VPurstell Kevin D · Burnt Hills, NYBuilt 1978 · S/N 1262-78N5503YBundt Benjamin L · Montebello, CABuilt 1978 · S/N 418-78N5504KWhite Traci Michelle · Manasquan, NJBuilt 1978 · S/N 1047-78N5504NWighs Terry L · Fairbanks, AKBuilt 1978 · S/N 1264-78N5504SBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1978 · S/N 277-78N5504YTarkington John W · Almyra, ARBuilt 1978 · S/N 423-78N5505HKupferschmidt W Alan Trustee · Lake Elmo, MNBuilt 1978 · S/N 1038-78N5505MCapozzi Eugene L · Kalispell, MTBuilt 1978 · S/N 424-78N5505NMargolies Lars · Goldens Bridge, NYBuilt 1978 · S/N 1266-78N55065Lynch Timothy B · Aguadilla, PRBuilt 1978 · S/N 427-78N55067Hinsch Delano G · Larchwood, IABuilt 1978 · S/N 428-78
Back to AD 2000-25-02 R1