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.

N7556BLund Kevin J · Williamson, GAS/N 7FC58N7556FWetzel Gehred · Factoryville, PABuilt 1969 · S/N 732-70N7557BTovani Michael O · Windsor, CABuilt 1957 · S/N 7FC-59N7558BGreene Bailey Michael · Maiden, NCBuilt 1957 · S/N 7FC-60N7558FSchaller Lee · New Athens, ILBuilt 1969 · S/N 226-70N7559EMorley Thomas O · Emmett, IDS/N 7FC-256N7559FDodge Donald V · Newnan, GAS/N 208-70N7560FCitabria Club LLC · Baton Rouge, LABuilt 1969 · S/N 733-70N7561BWilkinson Charles F · Maiden, NCBuilt 1957 · S/N 7FC-63N7561FRivers Robert A · Oxford, NCBuilt 1969 · S/N 267-70N7563FPayne Jimmy D · Newnan, GABuilt 1969 · S/N 227-70N7564BHegel Tina Elizabeth · Bonney Lake, WABuilt 1957 · S/N 7FC-66N7565ESouthworth Grant J · Bloomer, WIBuilt 1958 · S/N 7FC-259N7566EBeausoleil-Holt Alyson L · Jackson, NJBuilt 1958 · S/N 7FC-260N7567BWasson Tom L · Lakeport, CAS/N 68N7567EWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1958 · S/N 7EC-679N7567FMansfield Heliflight Inc · Milton, VTS/N 234-70N7568ETaylor Robert S · Ivoryton, CTS/N 7FC-261N7568FTranbarger Tad E · Macksville, KSBuilt 1969 · S/N 229-70N7569EPaul Mark A · Warren, OHBuilt 1958 · S/N 7FC-263N7569FMainero Tanner R · Chehalis, WABuilt 1969 · S/N 731-70N7570EOgan Jerald · Pierre, SDBuilt 1958 · S/N 7FC-262N7570FReichelt Christopher M · Mocksville, NCBuilt 1970 · S/N 235-70N7571BSterling C Bain Jr · Alexandria, LABuilt 1957 · S/N 7FC-76N7572ENibbe Douglas L · Saint James, MNBuilt 1958 · S/N 7GC-15N7572FKinder Mark E · Scottsdale, AZBuilt 1969 · S/N 230-70N7573FDirks Daniel P · Seguin, TXBuilt 1970 · S/N 757-70N7574BHuey Andrew G · Fulton, MOBuilt 1957 · S/N 7EC-613N7574EWalpierre LLC · Indiana, PABuilt 1958 · S/N 7GC-17N7574FDriskill Larry W · Lubbock, TXBuilt 1969 · S/N 209-70N7575BKeown William Joshua · Calhoun, GAS/N 7FC-78N7575EMajer Vaclav · Monterey, VABuilt 1958 · S/N 7GC-18N7576BAchamp LLC · Memphis, TNBuilt 1957 · S/N 7FC-79N7576ETalos Flyers Inc · South Bend, INBuilt 1958 · S/N 7FC-264N7576FPfleger Michael K · Scottsdale, AZBuilt 1969 · S/N 231-70N7577BWillis James R · Belleview, FLBuilt 1957 · S/N 7FC-80N7577EOstrich James T · Ocala, FLBuilt 1958 · S/N 7FC-265N7578FUscola Merle Jay · Wasilla, AKS/N 233-70N7579EStrand Ronald G · Osceola, WIBuilt 1958 · S/N 7FC-267N757ACLewis Aviation Inc · Wilmington, DEBuilt 1998 · S/N 809-98N757EJJames Marc Harry · Tryon, NCBuilt 2016 · S/N 1166-2016N757JLessing Aviation LLC · Denver, COS/N 512-2007N757MLSchaffer Michael W · New Meadows, IDBuilt 2013 · S/N 556-2013N757USPeasley Robert E · Lonsdale, MNBuilt 2019 · S/N 526-2019N7580EGhafouri Carly · Murrieta, CABuilt 1958 · S/N 7FC-268N7580FLybbert Randal Lorin · Moses Lake, WAS/N 736-70N7581EN7581e LLC · Grand Haven, MIBuilt 1958 · S/N 7FC-269N7582FCassano Graham S · Canandaigua, NYS/N 738-70N7583BGodin David M · Levant, MEBuilt 1957 · S/N 7FC-86N7583FDienst Lon C · Poplar Grove, ILBuilt 1970 · S/N 739-70
Back to AD 2000-25-02 R1