Skip to content

AD 2000-25-02 R1

Registered aircraft · 7,561

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

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

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.

N23BDCox Mike Trustee · Casper, WYBuilt 2009 · S/N 517-2009 N23JMMaynard Jared M · Kendall, NYBuilt 1998 · S/N 1244-98 N23LNJw Air LLC · Suffolk, VABuilt 1975 · S/N 550-75 N23PZInternational Air Services Inc Trustee · Carson City, NVS/N 975-2004 N2403EDawkins William T · Huntington Beach, CABuilt 1946 · S/N 7AC-5982 N2404EDunkley Bret Y · Kotzebue, AKS/N 7AC-5983 N2406EClark Edward P · Modesto, ILBuilt 1946 · S/N 7AC-5985 N2408EVirgin Stacey · Palmer, AKBuilt 1946 · S/N 7AC-5987 N240ACLetourneau University · Longview, TXBuilt 2004 · S/N 1390-2004 N240AKPhoenix Leasing LLC · Menomonee Falls, WIFirst renewal noticeBuilt 2013 · S/N 1129-2013 N240RJHavabaaz Aviation LLC · Great Falls, VABuilt 2010 · S/N 1103-2010 N240SSStroup Robert L · New River, AZS/N 345-80 N2411ER H Lindsay & Assoc Inc · Canby, ORBuilt 1946 · S/N 7AC-5990 N2416ENoack Emily B · Oshkosh, WIBuilt 1946 · S/N 7AC-5995 N2416YHalford William T · Hernando, MSBuilt 1956 · S/N 7BCM-90 N2419EBranco Martin G · Wright City, MOBuilt 1946 · S/N 7AC-5998 N241ACTwob LLC · Eden Prairie, MNBuilt 1999 · S/N 1373-98 N241PCPlucinski David J · San Clemente, CABuilt 2005 · S/N 1385-2005 N241RAGreat Escape Aviation Inc · Fort Lauderdale, FLBuilt 2002 · S/N 1322-2001 N2420ECabelka David M · Wausau, WIBuilt 1946 · S/N 7AC-5999 N2421EOrahood Matthew A · Carmel, INBuilt 1946 · S/N 7AC-6000 N2423Dinstel Daniel A · Alzada, MTBuilt 1960 · S/N 7GCB-55 N2425ECutsforth Gary L · Palmer, AKBuilt 1946 · S/N 7AC-6004 N2426EEngland Don A · Casa Grande, AZBuilt 1946 · S/N 7AC2481 N242BCElemental Aviation Lc · Wichita, KSBuilt 2011 · S/N 534-2010 N2434ERoop Robert S · Shreveport, LABuilt 1946 · S/N 7AC-6013 N2435EHaecker Howard Ivan · Canyon Lake, TXBuilt 1946 · S/N 7AC-6014 N2436ELubonovic Thomas M · New Carlisle, OHBuilt 1946 · S/N 7AC-6015 N243KJeffryes Richard B · Creswell, ORFirst renewal noticeBuilt 1946 · S/N 7AC 2710 N243MAJ W Peterson Inc · Warren, MNBuilt 2003 · S/N 479-2003 N2440EOsteen A Keith · Brevard, NCBuilt 1946 · S/N 7AC-6019 N2443EMancini Drew · Commerce, GABuilt 1946 · S/N 7AC-6022 N2450EWalton Camaron · Sherwood, ARBuilt 1946 · S/N 7AC-6030 N2451ENowakowski Donald K Trustee · Gilbert, SCBuilt 1946 · S/N 7AC-6031 N2452EDugan Ronald C · Rogers City, MIBuilt 1946 · S/N 7AC-6029 N2456EPorter Flying Service Inc · Chico, CAS/N 6035 N2459EStopa Gregg · Middletown, NYBuilt 1946 · S/N 7AC-6037 N2459QBerg Gabriel · Port Angeles, WABuilt 1969 · S/N 711 N245BCBambach Gregory Alan · Manistique, MIBuilt 2018 · S/N 1175-2018 N245SFLindley Robert F III · Williamson, GABuilt 2001 · S/N 880-2001 N2463EGustafson David H · Kingwood, TXBuilt 1954 · S/N 7AC-6042 N2464ESkov Mckinley · Bozeman, MTBuilt 1946 · S/N 7AC-6043 N2468WGodwin Gerald · Orange, TXS/N 886-2001 N246KKeeton James H · Atlanta, GABuilt 1991 · S/N 658-91 N246RAJohnson Robert C · Dallas, TXBuilt 2005 · S/N 1398-2005 N246SGLensis Thomas M · Wilmington, NCBuilt 2003 · S/N 473-2003 N2472ELow & Slow LLC · Warner Robins, GABuilt 1946 · S/N 7AC-6051 N2478EMalloy Kevin J · Mullica Hill, NJBuilt 1946 · S/N 7AC-6057 N2479EFrog Pond Aviation LLC · Sherman, TXBuilt 1946 · S/N 7AC-6058 N247BCPlane Nutz LLC · Sugar City, IDBuilt 2011 · S/N 544-2011

Back to AD 2000-25-02 R1