Skip to content

AD 2000-25-02 R1

Registered aircraft · 7,560

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.

N139PCSavage David Edward · American Falls, IDBuilt 2002 · S/N 1339-2002 N13JHL J H Consulting LLC · Greenleaf, IDBuilt 2021 · S/N 617-2021 N13LGN13lg Aviation LLC · Dover, DEBuilt 2017 · S/N 1473-2017 N13PBZimmerman Michael P · Verona, WIBuilt 2022 · S/N 1483-2022 N13PMFly High Aviation LLC · Melrose Park, ILBuilt 1977 · S/N 305-77 N13RHChrist Graham Charles · Mandeville, LABuilt 1973 · S/N 973-73 N13WLRegistration Pending · Bristol, SDRegistration pendingBuilt 2020 · S/N 605-2020 N13YCBuckin 307 Taildraggers LLC · Casper, WYBuilt 1976 · S/N 590-76 N1404EPanko Jessica E · North Pole, AKBuilt 1946 · S/N 7AC-4952 N14050M & K Flying Service Inc · Hot Springs Vill, ARBuilt 1975 · S/N 857-75 N1406EJeffries Joy L · Louisville, KYBuilt 1946 · S/N 7AC-4968 N1408ELeaseair LLC · Wilmington, DEBuilt 1946 · S/N 7AC-4971 N1409EMattson Eric J · Saint Paul, MNBuilt 1946 · S/N 7AC-4972 N1413EHeinke Nils A · Elkins, WVBuilt 1946 · S/N 7AC-4976 N1414EKlaas Jeffrey M · Lakeway, TXBuilt 1946 · S/N 7AC-4977 N1415ERegistered aircraftBuilt 1946 · S/N 7AC-4978 N1418EAerowood Aviation LLC · Monroe, NCBuilt 1946 · S/N 7AC-4981 N141BCAtkinson Air LLC · Dixon, CABuilt 2020 · S/N 602-2020 N141BHBob Hannah Aviation LLC · Caldwell, IDBuilt 2022 · S/N 623-2022 N141CHRegistered aircraftBuilt 1979 · S/N 324-79 N141JSGeurin Ronnie C · Murray, KYBuilt 1979 · S/N 383-79 N141SCVance John C · Coleman, TXBuilt 2000 · S/N 1286-99 N141SEHydro Flyers LLC · Woodside, CABuilt 2006 · S/N 1024-2006 N1421EDyer Barbara A · Ocala, FLBuilt 1946 · S/N 7AC-4984 N1427ESowles John W · North Yarmouth, MEBuilt 1946 · S/N 7AC-4990 N142ACFly For Fun LLC · Rockville, MDBuilt 1992 · S/N 683-92 N142TSAmberly Holdings LLC · Fleming Island, FLS/N 486-74 N1430EWallace Aviation Inc · Wallace, NEBuilt 1946 · S/N 7AC-4993 N1436ECook Charles L · Butler, MOBuilt 1946 · S/N 7AC-4999 N1438ERegistered aircraftBuilt 1946 · S/N 7AC-5001 N143PCFuqua Royce Owen · Early, TXBuilt 2004 · S/N 1379-2004 N1448EWissler Brekhus Susan M · Tenino, WABuilt 1946 · S/N 7AC-5011 N14499Cox Alex E · Watson, ARBuilt 1948 · S/N 7DC42 N144BCThomas George E · Rice, WAS/N 188 N144DHSky 1 Inc · Wilmington, DEBuilt 1996 · S/N 1219-96 N1452EMcarthur Heinz M · Cary, NCBuilt 1946 · S/N 7AC-5015 N1457EPrather Carl · Gilroy, CABuilt 1946 · S/N 7AC-5020 N145ACTrusler William L · Magnolia, TXBuilt 1992 · S/N 684-92 N145BCMazur Steve J · Fairbanks, AKBuilt 2004 · S/N 456-2004 N145RWHolder Robert W · Pittsfield, PABuilt 1971 · S/N 800-71 N1467EKoehn Jerry L · Cimarron, KSS/N 7AC-5030 N146MAHong Ted · San Jose, CABuilt 2002 · S/N 903-2002 N146MCGibson William V · Aberdeen, MSS/N 54-73 N1470ZBig Tree LLC · Caldwell, IDS/N 189-76 N1472ESchwantz Charles Macon Thomas · Azle, TXBuilt 1946 · S/N 7AC-5035 N1475ELittle Jack E · Granbury, TXBuilt 1946 · S/N 7AC-5038 N1476ELafave Alex T · Basehor, KSBuilt 1946 · S/N 7AC-5039 N147BCCard Logging Co Inc · Eugene, ORBuilt 2003 · S/N 447-2003 N147MAReaddick Rocy W · Kingsland, GABuilt 2005 · S/N 501-2005 N147PCAlexander John S · Warrensburg, NYBuilt 2004 · S/N 1366-2004

Back to AD 2000-25-02 R1