Skip to content

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

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.

N4061EHarrison Hayden F · Mckean, PABuilt 1947 · S/N 11BC-149 N4063AWeidman Clare D · Eagle Rock, VABuilt 1947 · S/N 47-1263 N4064AAdirondack Air LLC · Wilmington, DEBuilt 1947 · S/N 7BCM-145 N4064EHurlbert Ralph E · Raymond, SDBuilt 1947 · S/N 11BC-152 N4067EJasinski Jack J · Necedah, WIBuilt 1947 · S/N 11BC-155 N4069EReese Troy D · Brooten, MNBuilt 1947 · S/N 11BC-157 N406ACLequire Paul D · Kingston, TNBuilt 1998 · S/N 406-98 N406JKKolstad Jon C · Glasgow, MTBuilt 1976 · S/N 231-76 N4070EDelaney Patrick J · Marion, TXS/N 11BC-158 N4075EKimbrough Dale M · Goodlettsville, TNS/N 11BC-167 N4079ESpranger Paul L · Valley Center, KSBuilt 1947 · S/N 11BC-173 N408JNTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1966 · S/N 58 N4091E4091e LLC · Newport, MEBuilt 1947 · S/N 11CC-1 N4094EScholl Carl W · Borrego Springs, CABuilt 1947 · S/N 11CC-4 N4098EMaltz Lawrence · Georgetown, TXBuilt 1947 · S/N 11CC-7 N409JSJones Clayton S · Nacogdoches, TXS/N 7AC-3369 N40ACRadecki Louis · Helenville, WIBuilt 1991 · S/N 644-91 N40EMYour Moms Upset LLC · Saint Paul, MNS/N 696-92 N40JMAll Breeds Combined LLC · Kalispell, MTS/N 540-2011 N40SGZeliff Aviation LLC · Batavia, NYS/N 550-2012 N4100AWright David W · Moultrie, GABuilt 1947 · S/N 7BCM-478 N4100YLofton Charles T · Georgetown, MNBuilt 1976 · S/N 944-76 N4101EMaidens James M · Bath, MIFirst renewal noticeS/N 11CC33 N4101YBower Gary R · Miranda, SDBuilt 1976 · S/N 230-76 N4104EFlint Gregory C · Bristol, CTBuilt 1947 · S/N 11CC-13 N4104YBurgett Gary · Galena, AKBuilt 1976 · S/N 945-76 N4105EPalmer Matthew B · Riverside, CABuilt 1947 · S/N 11CC14 N4110YHeiderscheidt Cory · Sleepy Eye, MNBuilt 1976 · S/N 1175-76 N4111EHeller Kurt L · Skwentna, AKBuilt 1947 · S/N 11CC-21 N4111YHousley Jaclyn R · Wasilla, AKBuilt 1976 · S/N 946-76 N4113YKlintrin Collectibles LLC · Downers Grove, ILBuilt 1976 · S/N 591-76 N4114YLight & Variable LLC · Arlington, VABuilt 1976 · S/N 947-76 N4115YN4115y LLC · Munday, TXS/N 948-76 N41171Wilco Aviation LLC · Jonesboro, ARS/N 735-70 N4117YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 592-76 N4118VSchaff Cole M · Mandan, NDBuilt 1946 · S/N 1389 N4119YSmith Robert R · Benton, LAS/N 276-76 N411DWKibler Joseph T · Mount Airy, MDBuilt 1996 · S/N 772-96 N411LRHensley Ty · Lake Wylie, SCBuilt 1992 · S/N 679-92 N411YSky Pirate LLC · Provo, UTBuilt 1977 · S/N 326-77 N4120EWilliams Barrett G · Homer, AKS/N 11CC29 N4121YStotts Jimmy W · Jonesboro, ARBuilt 1976 · S/N 1176-76 N4122YPetter David · Stuttgart, ARBuilt 1976 · S/N 333-76 N4124YConsolidated Aviation Services LLC · Seymour, TNBuilt 1976 · S/N 593-76 N4125ESmith John R · Greensboro, GABuilt 1947 · S/N 11CC-34 N4128EAlsup Alan D · Gainesville, TXBuilt 1947 · S/N 11CC-37 N412KBBlagg Kevin B · Dumas, ARBuilt 2005 · S/N 476-2005 N4130EBouton Glenn A · Kasilof, AKBuilt 1947 · S/N 11CC-39 N4132ELuggar Will A · Solway, MNBuilt 1947 · S/N 11CC-41 N4132YMartin Beaux R · Calhoun, LAS/N 234-76

Back to AD 2000-25-02 R1