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.

N372FTTownsend Frederick H · Ortonville, MIBuilt 1972 · S/N 832-72N3730EKoening John A · Boca Raton, FLBuilt 1947 · S/N 7AC-7021N3732ESturdevant Robert M · Trappe, MDBuilt 1947 · S/N 7AC-7023N3736EAvila Raul · Lakeland, FLS/N 7BCM-7027N3737EWulkn Brad O · Hector, MNBuilt 1947 · S/N 7AC-7028N3738EWright Peter S · Watertown, WIBuilt 1947 · S/N 7AC-7115N3740ELinstad Daniel E · Canby, ORBuilt 1947 · S/N 7AC-7127N3743EWings Up LLC · Saint Augustine, FLS/N 7AC-7120N3744EZimmermann Mark · Granbury, TXBuilt 1947 · S/N 7AC-7034N3751EBahmann Frank · Dade City, FLBuilt 1947 · S/N 11AC-S2N3753EVerduin William D · Zeeland, MIS/N 7AC-7042N3756ENortheast Cubs LLC · Wilmington, DEBuilt 1947 · S/N 11AC-S-3N3757EWood Thomas D Jr · Irvington, ALBuilt 1947 · S/N 7AC-7047N3758EFenger Paul · Cottonwood, MNBuilt 1947 · S/N 11AC-S-4N3759ECunningham Robert F · Gibraltar, MIBuilt 1947 · S/N 7AC-7048N375KSchlesinger Dmitri P · Los Angeles, CABuilt 2010 · S/N 530-2010N375TJohnson Nick H · Houston, TXBuilt 2023 · S/N 1209-2023N37618Eide Larry D · Minot, NDBuilt 1948 · S/N 7DC-150N3763EFlywithgeorge Inc · Madison, SDS/N 11AC-S-6N3769EMather Tiffany S · Huron, OHBuilt 1947 · S/N 11AC-S-7N3770Joebravo Aviation LLC · Derby, KSS/N 204-75N3772EFisher Frederick D · Frederick, MDBuilt 1947 · S/N 7AC7046N3774EDanner Charles L · Oak Harbor, OHBuilt 1947 · S/N 7AC-7057N3775EOrahood Douglas R · Cicero, INBuilt 1947 · S/N 7AC-7058N37778Davidson Milton P · New Folden, MNS/N 2102N3777EMccrary Donald R · Greensburg, INBuilt 1947 · S/N 11AC-S-10N3779EHeise Roger H · Clayton, NYBuilt 1947 · S/N 7AC7061N377HGHunt James J · Dalton, PABuilt 1998 · S/N 1252-98N3782EOlson David A · New Underwood, SDBuilt 1947 · S/N 7AC-7065N3784EAnderson Timothy H · Janesville, WIBuilt 1947 · S/N 11AC-S-12N3786EHughes J Lonny · Lake Crystal, MNBuilt 1947 · S/N 7AC-7068N378ACRagwing Aviation LLC · Palo Alto, CABuilt 1999 · S/N 1378-99N378JGByrkit Dale D · Clay Center, NEBuilt 1992 · S/N 680-92N378JPN8zw LLC · East Hampton, NYBuilt 2005 · S/N 980-2005N3790EFicklin Robert L · Fairbury, ILBuilt 1947 · S/N 11AC-S-14N3793EAllen Scott L · Ogallala, NEBuilt 1947 · S/N 11AC-S-16N3797EHammond Michael L · Georgetown, TNBuilt 1947 · S/N 7AC-7075N3798BPintamo Michael J · Longmont, COS/N 7DC-50N3798EBarr Myron G · Spanaway, WAFirst renewal noticeS/N 7AC-7043N3799EGoebel Jacob R · Rhome, TXBuilt 1947 · S/N 11AC-S-18N37BYTubreaux Aviation Services LLC · Shreveport, LABuilt 2004 · S/N 951-2004N37DAero Equities LLC · Ventura, CABuilt 1973 · S/N 570-73N37KFFillips Karl · Alvin, TXS/N 317-77N37LVLegros Aviation Services Inc · Crowley, LABuilt 1992 · S/N 695-92N37TRTrofimchuck Matthew P · Coal City, ILBuilt 1996 · S/N 775-96N3800EMorris Delbert A · Cashmere, WAS/N 11AC-S19N3806EDavidson Logan T · Germantown, OHBuilt 1947 · S/N 11AC-S-24N380KCitabria Corporation · Wilmington, DEBuilt 2011 · S/N 543-2011N380RADarnell Charles Bert · Glen Allan, MSBuilt 2005 · S/N 1380-2005N3811ESale Reported · Watsonville, CASale reported, canceledBuilt 1947 · S/N 11AC-S30
Back to AD 2000-25-02 R1