Registered aircraft · 108,428

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: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

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.

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

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.

N112WWAmerican Smooth Aviation LLC · Rock Hill, SCFirst renewal noticeBuilt 1977 · S/N 310R1215 N112XAir Corriente LLC · Columbia, TNBuilt 1966 · S/N D-8121 N112YMedeiros Joel · Lumberton, NJBuilt 2011 · S/N 9000-1 N1130MTelbo LLC · Vonore, TNBuilt 1965 · S/N D-8023 N1130QHedges William S · Algona, IABuilt 1997 · S/N EA-598 N11312Clarity Aviation LLC · Anchorage, AKS/N 1021 N11316Torreano Paul J · Lockport, NYBuilt 2019 · S/N 7357 N1131JStringer Greg A · Egg Hbr Twp, NJBuilt 1954 · S/N E3B-438 N1131LSeehafer Paul D Trustee · Junction City, WIBuilt 1964 · S/N 293 N1131MWhite Tom · South Charleston, WVBuilt 1975 · S/N 18264228 N1131PDBA Congdons Aviation Service · Anchorage, AKS/N 23-141 N1131SBest Devereux Igor · Salt Lake City, UTBuilt 2005 · S/N 516 N1131TCaldwell Alexander S · Tulare, CABuilt 2002 · S/N 11222 N1131WPrice Steven D · Healdsburg, CABuilt 1976 · S/N 18264584 N1132LContact Point Inc · Amarillo, TXBuilt 1964 · S/N 294 N1132PR & S Stuart Co Inc · Wilmington, DEBuilt 1955 · S/N 23-142 N1132QWattum Investments LLC · Kodiak, AKBuilt 1977 · S/N 32-7740046 N1132TPeck Russell C · Memphis, TNBuilt 1976 · S/N TC-1962 N1132UMjolhus Knut G · Amarillo, TXBuilt 1982 · S/N 21064669 N1132WC Flying K Aviation LLC · Savery, WYFirst renewal noticeBuilt 2006 · S/N 172S10125 N1132XWest Coast Equipment Leasing LLC · Englewood, COBuilt 2006 · S/N 172S10316 N11330Leikala Douglas A · Fairport Harbor, OHBuilt 1975 · S/N 17702332 N11334Martin James David · Graford, TXBuilt 1931 · S/N 247 N1133APedota Darien · Northport, ALBuilt 1980 · S/N CE898 N1133KBayramoglu Ulug · Carrollton, TXBuilt 2015 · S/N 21234 N1133QHaggard Haley G · Springer, OKBuilt 1963 · S/N 310H0133 N1133UMustachio Donald · East Stroudsburg, PABuilt 1976 · S/N 17266862 N1133XBristol Aircraft Leasing LLC · Willoughby, OHBuilt 1967 · S/N 670504 N1134ABeaver Creek Aviation LLC · Clinton, OKBuilt 1997 · S/N E-3066 N1134DFma Auto Sales LLC · Greensboro, NCBuilt 2005 · S/N 18281605 N1134PSutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 23-146 N1134UWells William L · Santa Cruz, CABuilt 1976 · S/N 17266863 N1134WAbs Aviation LLC · Cleveland, TNFirst renewal noticeBuilt 1997 · S/N E-3067 N1134XWard Bernard Holman III · Wichita Falls, TXBuilt 1997 · S/N E-3074 N1135Plambeck Dan · Idaho Falls, IDBuilt 1971 · S/N 001 N1135FLong Duane C · Baskin, LAS/N 17272961 N11364Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1995 · S/N 2508 N11368Adkins Ian B · Dahlonega, GABuilt 1975 · S/N 17702333 N1136ARegistered aircraftBuilt 1980 · S/N E-1694 N1136GBurnside Thomas L · Kansas, ILBuilt 1978 · S/N 18266300 N1136NPga Re LLC · Midland, TXBuilt 1996 · S/N E-3053 N1136PBjmj LLC · Greensboro, NCBuilt 1996 · S/N E-3044 N1136SBig Sky Beech LLC · Red Oak, IABuilt 1996 · S/N E-3054 N1136VN1136v LLC · Sheridan, WYBuilt 1996 · S/N EA-592 N1136YBonanza Aviation Inc Trustee · Wilmington, DEBuilt 1996 · S/N E-3050 N11378Registered aircraftBuilt 1975 · S/N 17702335 N11379Bas Part Sales LLC · Greeley, COBuilt 1999 · S/N 20608077 N1137JDaugusta Richard J · Lexington, MAS/N 137 N1137MN1137m LLC · Bentonville, ARBuilt 1977 · S/N 21061921 N1137UFoscap Air LLC · Las Vegas, NVBuilt 1976 · S/N 17266866

Back to AD 2007-04-19 R1