Skip to content

Registered aircraft · 54,837

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

N122FSiver Creek Capital LLC · Emery, SDS/N 21058967 N122JBWestwind Aircraft Leasing LLC · Phoenix, AZBuilt 2003 · S/N 208B1025 N122JHValentine Terence S · Glennallen, AKBuilt 1966 · S/N R-172-0086 N122JSGraham Design Services Inc · Dawsonville, GABuilt 1979 · S/N 18266866 N122KSPt Arts LLC · Grand Rapids, MIBuilt 1966 · S/N 17255255 N122MJHyper Flight Inc · Seattle, WABuilt 1977 · S/N 17270043 N122MWWalker Kyle E · Lawrence, KSBuilt 1979 · S/N R18201276 N122PWKal Aero Flight Instruction LLC · Mattawan, MIBuilt 1966 · S/N 17255433 N122RPWerner Bryce R · Blue Earth, MNBuilt 1966 · S/N 17254543 N122SBCessna Twin Flyers LLC · Calhoun, TNS/N 310R0873 N122SSGrain Belt Aviation LLC · Malcolm, NEBuilt 1975 · S/N 17264842 N122SWAmerican Petroleum Corp · Ratliff City, OKS/N 421B0506 N122TGAnzalone Donald Michael · Durango, COBuilt 1980 · S/N 18267533 N122TTEveraert Filip L · Midland, MIBuilt 1974 · S/N 18262858 N122VCTurner Terrance A · Anchorage, AKBuilt 1973 · S/N 18502203 N122WB2sea2it LLC · Ossining, NYBuilt 1973 · S/N 33701487 N122WRRangers Flying Club Inc · Eden Prairie, MNBuilt 1975 · S/N 177RG0744 N122WTStoimenov Kirill H · San Andreas, CABuilt 1977 · S/N 18266094 N122XPWatch Ya Head Aviation 1 LLC · Zionsville, INS/N R1722055 N1231FRegistration Pending · Wasilla, AKRegistration pendingBuilt 1975 · S/N 18502793 N1231QMclin Robert J · Mays Landing, NJBuilt 1971 · S/N 15072531 N1232FLloyd Land Plane I LLC · Brighton, COBuilt 1975 · S/N 18502794 N1232KCorporate Air LLC · West Mifflin, PABuilt 1984 · S/N 340A1815 N1232QPeres Kenneth V · Erie, PABuilt 1971 · S/N 15072532 N1232UOrganization Of Black Aerospace Professionals Inc · Westchester, ILS/N 17266928 N1232YPa1 208b-0566 LLC · Fort Lauderdale, FLBuilt 1996 · S/N 208B0566 N12330Liller Kenneth F · New Port Richey, FLBuilt 1973 · S/N 17261932 N12331N Conti Inc · Boyertown, PABuilt 1973 · S/N 17261933 N12335Truscott Jon M · Sunfield, MIBuilt 1973 · S/N 17261935 N12336Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 17261936 N12339Howard Ronald W · Okeechobee, FLBuilt 1973 · S/N 17261937 N1233BSutton Aircraft Salvage LLC · Palmer, AKS/N 51215 N1233FFlyboyz LLC · Bourbon, MOS/N 182-61270 N1233MFrench Rollie T · Vermillion, SDBuilt 1975 · S/N 18264251 N1233QReach For Skies LLC · San Antonio, TXS/N 15072533 N1233UMagnum Air LLC · Camp Hill, PABuilt 1976 · S/N 17266929 N1233VFlybuy Investments LLC · Natchitoches, LAS/N R1722147 N1233WDouble Crown Investments LLC · Earlsboro, OKBuilt 1970 · S/N 18260263 N1233YPoland Marvin W · Tawas City, MIBuilt 1962 · S/N 15059633 N12341Merl Robert B · Los Alamos, NMBuilt 1973 · S/N 17261938 N12342Simpson Elden G · Prineville, ORBuilt 1973 · S/N 17261939 N12343Albany Aviation Ny LLC · Nassau, NYBuilt 1973 · S/N 17261940 N12346Baidenmann Maralin Frances · Bend, ORBuilt 1973 · S/N 17261941 N1234FSkydive New Hampshire LLC · Moab, UTFirst renewal noticeS/N 33444 N1234SGale Jeremy C · Clear Lake, WIS/N 17254335 N1234WCuellar Mauricio Dominguez · Tampa, FLBuilt 1970 · S/N 414-0043 N1234YDe Jong Thomas · Buckeye, AZBuilt 1980 · S/N 18503944 N12360Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261947 N12365Singh Jaganpreet · Bakersfield, CABuilt 1973 · S/N 17261950 N12366Zimmerman Michael P · Verona, WIBuilt 1973 · S/N 17261951

Back to AD 97-01-13