Skip to content

Registered aircraft · 26,231

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N1669KDaphna Inc · Middletown, DEBuilt 1946 · S/N 4396 N1669QIvy James E · Alba, TXBuilt 1971 · S/N 15072969 N166JALazy 8 LLC · Renton, WABuilt 2010 · S/N 16200010 N166LJWilcoxen Paul · Wichita, KSS/N 18756 N167Palmer Michael · Crystal Lake, ILBuilt 1950 · S/N 19225 N1670FTillamook Pilots Association · Tillamook, ORBuilt 1966 · S/N 17255065 N1670VHale Justin A · Cheyenne, WYS/N 13842 N1670YMarshall Gregory A · Sauk Rapids, MNBuilt 1962 · S/N 17249370 N1671QRegistered aircraftBuilt 1971 · S/N 15072971 N1671VHarris James J · Saint Marys, OHBuilt 1947 · S/N 13843 N1671YDavid Dahl · Shevlin, MNBuilt 1962 · S/N 17249371 N1672QHall Donna L · Pulaski, TNS/N 15072972 N1672VKott Edward A · Lake City, FLS/N 13844 N1672YSmith David W · Texarkana, TXBuilt 1962 · S/N 17249372 N1673FHopkins Ronald J · Salt Lake City, UTFirst renewal noticeBuilt 1966 · S/N 17255068 N1673YLentz Gregory · Green Forest, ARBuilt 1962 · S/N 17249373 N1674FPlane Nuts Aviation LLC · Livingston, LABuilt 1966 · S/N 17255069 N1674KLa Roche Joseph F · Waukesha, WIBuilt 1946 · S/N 4401 N1675Meuer Gary D · Tullahoma, TNBuilt 1970 · S/N F-6128 N1675DRatcliff Whitcomb T · Carnation, WABuilt 1952 · S/N 20317 N1676DJohnston Brent A · Galena, OHBuilt 1952 · S/N 20318 N1676FBrunson Tim R · Gilmer, TXS/N 17255071 N1676KYowell Kirby D · Phoenix, AZBuilt 1946 · S/N 4403 N1676YGray Bryan · Colorado City, TXBuilt 1962 · S/N 17249376 N16771Tintman Inc · Spokane, WAS/N 15066452 N1677KKnutson Chad H · Volga, SDBuilt 1946 · S/N 4404 N1678FHorne William D II · Oxford, MSBuilt 1966 · S/N 17255073 N1679FCrawford Anthony B · Hampton Cove, ALBuilt 1966 · S/N 17255074 N1679QRegistration Pending · Fulton, MSRegistration pendingBuilt 1971 · S/N 15072979 N167RAWojnar Ronald T · East Troy, WIBuilt 2008 · S/N 1020-2007 N167SFRopp Dwight F · Salome, AZBuilt 2003 · S/N S9812-0180 N1680DTrade Winds Aviation Holdings LLC · Lewes, DEBuilt 1952 · S/N 20322 N1680FBoyette Robert Wayne · Ashford, ALBuilt 1966 · S/N 17255075 N1680QHanke Kenneth O · Clio, SCBuilt 1971 · S/N 15072980 N1681DKaiserauer Brian · Longmont, COBuilt 1952 · S/N 20323 N1681FRegistered aircraftBuilt 1966 · S/N 17255076 N1682FBravo Zak Air LLC · Lake Wales, FLBuilt 1966 · S/N 17255077 N1682VShuck Michael W Trustee · Maize, KSBuilt 1947 · S/N 13854 N1682YStorby Steven R · Osceola, WIBuilt 1962 · S/N 17249382 N1683YKnutson Daniel T · Lodi, WIBuilt 1962 · S/N 17249383 N1684FRedmon Robert J · Gallatin, TNBuilt 1966 · S/N 17255079 N1684YKoenig William J · Benedict, MDS/N 17249384 N1685DAngrisani Robert J · Sacramento, CABuilt 1952 · S/N 20327 N1685QMore Right Rudder LLC · Newnan, GABuilt 1971 · S/N 15072985 N1685VCreglow Jacob A · Soldotna, AKS/N 13857 N1686FAdams Claude T Jr · Palmer, AKBuilt 1966 · S/N 17255081 N1686QJ3 Jets LLC · Bellaire, TXBuilt 1971 · S/N 15072986 N1686VByers Ricky A · Hereford, AZBuilt 1947 · S/N 13858 N1686YBrissel John M · El Paso, TXBuilt 1962 · S/N 17249386 N1687FTigerair 2020 LLC · Newark, DES/N 17255082

Back to AD 94-05-05 R1