AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-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:2007-04-19-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.

N501GLSharp Aviation LLC · Pauls Valley, OKBuilt 1973 · S/N 0501N501GTPollux Aviation Ltd · Wasilla, AKBuilt 2005 · S/N 10768N501HLAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1995 · S/N 2500N501JAAlongi John J · Downers Grove, ILBuilt 1990 · S/N 501-RN501KPWasson Ronald L · Colleyville, TXBuilt 1974 · S/N TJ-21N501LFMilchev Valentin · New Hampton, NHBuilt 1995 · S/N 1758N501MAContinental Aerospace Technologies Inc · Mobile, ALBuilt 2021 · S/N 2881479N501MERoby Gregory Carl · Owensboro, KYS/N 11N501MLVotava Paul A · Mcintosh, MNBuilt 1970 · S/N TH-72N501MPManzoor Khan · Stockton, CABuilt 1978 · S/N 17270318N501NANasa Langley Research Center · Hampton, VABuilt 2001 · S/N 0012N501NGCummings Johnny R IV · Clearwater, FLBuilt 1970 · S/N 18260486N501PFTraumflieger LLC · Lancaster, PABuilt 2001 · S/N 40021N501PLDick Timothy R · Fox Lake, ILBuilt 2001 · S/N 5272N501RADalton Charles · Auburn, NYBuilt 1965 · S/N CD-957N501RDBackcountry Endeavours LLC · Dassel, MNBuilt 1992 · S/N 2164N501REIndependence Aerospace LLC · Kennesaw, GABuilt 1963 · S/N 30-194N501RVSaunders Steven M · Elizabeth City, NCBuilt 2006 · S/N 90305N501SBStevenson Randall J · Wildwood, MOS/N 310R0166N501SCSaz Dynamics LLC · Daly City, CABuilt 2005 · S/N 172S9883N501SDNordeen Christopher L · Salinas, CABuilt 1986 · S/N 8088CN501SFNomarco Inc · Woodburn, ORS/N 21061808N501SGMccair LLC · Mineral Wells, TXBuilt 1983 · S/N 32-8306003N501TCCourtney Aviation LLC · Columbia, CABuilt 1960 · S/N 500A-903-12N501TSFlying Tigers Flight School LLC · Houston, TXBuilt 1976 · S/N 17266839N501UAlba Leasing Services LLC · Scottsdale, AZBuilt 2020 · S/N 101/USN501WPTrue Course Aviation LLC · Ashville, NYBuilt 1977 · S/N 32R-7780476N501WTPeterson Floyd M · Lago Vista, TXBuilt 1979 · S/N TC-2194N501ZNorth Georgia Helicopters Inc · Calhoun, GAS/N 18-7836N50208Haus Jesse M · Fort Worth, TXBuilt 1974 · S/N 17264197N5020DSpiro Paul M · Anchorage, AKBuilt 1958 · S/N 51120N5020HBorreson Anthony · Mariposa, CABuilt 1975 · S/N 17265303N5020PThurston Steven C · Salisbury, NCBuilt 1958 · S/N 24-23N5020QHudson Thomas C Jr · Bessemer, ALBuilt 1968 · S/N 310N-0120N5020RMigliaccio Jason · Palm Bay, FLBuilt 1974 · S/N 17263261N5020SSchneider Robert R · Fort Benton, MTS/N 28R-35753N5020TBetlach Christopher Thomas · Kenmore, WABuilt 1972 · S/N 28R-7235175N5020WAndersen Richard W · Vail, AZBuilt 1961 · S/N 28-21N5020YStandridge Robert M · Norman, OKS/N 3246187N5021HAlamo Flyers LLC · Elmendorf, TXBuilt 1975 · S/N 17265304N5021JIntegrity Aviation LLC · Coatesville, INBuilt 1976 · S/N 310R0803N5021RWax Sally G · Louisville, KYBuilt 1974 · S/N 17263262N5022DSearey 806 LLC · Weirsdale, FLBuilt 1958 · S/N 51122N5022KElkins William S · Santa Fe, NMBuilt 1951 · S/N 21198N5022WHovendick William P · Lander, WYBuilt 1961 · S/N 28-23N50233Garofalo Dawn L · Bellingham, WABuilt 1972 · S/N U20601911N5023EHarned William C · Lebanon Junction, KYBuilt 1958 · S/N 50323N5023FCharlie Tango Enterprises LLC · Newport Beach, CABuilt 2004 · S/N 0842N5023JTexas State Technical College · Waco, TXBuilt 2001 · S/N 172S8964N5023LIsland Hoppers Seaplanes 2 LLC · Orlando, FLBuilt 1971 · S/N 480
Back to AD 2007-04-19 R1