OpenAirDocs.org
AD 2023-02-17

Registered aircraft · 3,180

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:2023-02-17')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2023-02-17')
  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.

N1003AOakshire Aviation LLC · Yakima, WABuilt 1978 · S/N P21000078N100DBState Of Wisconsin · Madison, WIBuilt 1980 · S/N 21063970N100LDPenning Jeffrey D · Clear Lake, IABuilt 1968 · S/N 17700990N1011Martin Rex L Trustee · Bakersfield, CABuilt 1980 · S/N 21064004N10171Fod Flyers LLC · Fort Dodge, IABuilt 1975 · S/N 17702315N101CWAtlanta Technical College · Atlanta, GABuilt 1972 · S/N 177RG0290N10213Sparks Tom · Palestine, ILBuilt 1975 · S/N 17702317N1028RGarner Donald G · Greeley, COBuilt 1980 · S/N P210-00401N102KYPatriot Aviation LLC · Rostraver Township, PABuilt 1978 · S/N P21000093N10305Blunt Samuel N · Summerville, SCBuilt 1975 · S/N 17702319N1039GFountain Keith E · Jacksonville, NCBuilt 1979 · S/N 21063174N10410Clark George A · Worcester, MABuilt 1975 · S/N 17702321N10420Kinney Powell Mcvay · Coppell, TXBuilt 1975 · S/N 17702324N104AFNance David B · Quinton, VABuilt 1967 · S/N 17700238N104WDHill Keith D · Kirby, ORBuilt 1979 · S/N P21000366N105DFWestwood Aero Inc · Porterville, CABuilt 1986 · S/N 21064999N1075MDewitt Scott C · Corpus Christi, TXBuilt 1973 · S/N 177RG0295N107SKFitzpatrick William M · Cleveland, GABuilt 1973 · S/N 17702004N108ATKirschner John R · Crystal Lake, ILBuilt 1971 · S/N 177RG0046N10HXIjh Farm Inc · Seminole, TXS/N 21063588N10TTHays John J Jr · Denton, TXBuilt 1978 · S/N P21000056N1101CHampton Brock W · Wichita, KSBuilt 1977 · S/N 17702673N1102CWakefield Aviation LLC · Mahopac, NYS/N 17702674N1105CLandon Jeff · Lancaster, CABuilt 1977 · S/N 17702675N110BDArgus Craig J · Atlantic City, NJBuilt 1981 · S/N 21064427N110DWSlater Spray Service Inc · Maddock, NDBuilt 1974 · S/N 177RG0495N110KMCars Planes And Land LLC · Fuquay Varina, NCBuilt 1983 · S/N 21064800N110PFUniversity Of Detroit Flying Club Inc · Livonia, MIS/N 17702629N11103Hennigan Shellie · Jonesboro, LAS/N 17702325N11172Skaaire Society · Madison, WIBuilt 1975 · S/N 17702327N111VFCottle John A DBA · Watsonville, CABuilt 1980 · S/N 21064005N11226Box Jon A · Carrizo Springs, TXBuilt 1975 · S/N 17702329N1123UTroy Investment Co 1 L P · Brownsville, TXBuilt 1982 · S/N 21064667N11271No Coop Cardinal LLC · Sonoma, CABuilt 1975 · S/N 17702330N112NCFrance Jay D · Colbert, GABuilt 1970 · S/N 17701598N1132UMjolhus Knut G · Amarillo, TXBuilt 1982 · S/N 21064669N11330Leikala Douglas A · Fairport Harbor, OHBuilt 1975 · S/N 17702332N11368Adkins Ian B · Dahlonega, GABuilt 1975 · S/N 17702333N11378Registered aircraftBuilt 1975 · S/N 17702335N113TTHaley John R · Tomball, TXBuilt 1979 · S/N P21000281N11429Schwartz David J · Bellaire, MIBuilt 1975 · S/N 17702338N11476Shannon Kenneth H · Washington, DCBuilt 1975 · S/N 17702340N11500Semmes James · El Centro, CABuilt 1975 · S/N 17702342N11506Fidk Inc · Warrenton, VABuilt 1975 · S/N 17702343N11564Ajw Management LLC · Scottsdale, AZBuilt 1975 · S/N 17702347N11566Monterrosa Frank J · Lincoln, CABuilt 1975 · S/N 17702348N11585Registered aircraftS/N 17702349N11596Tagart Charles · Senoia, GAS/N 17702352N11600Nolan James B · Chandler, AZBuilt 1975 · S/N 17702354N11608Aircraft Trade Group LLC · Scandia, MNBuilt 1975 · S/N 17702357
Back to AD 2023-02-17