Skip to content

Registered aircraft · 56,580

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N4214VGat Air & Ground LLC · Norwich, NYBuilt 1948 · S/N 18570 N42150Custom Air Solutions LLC · Broadway, VABuilt 1968 · S/N 18258875 N42151Foster Floyd W · Lyon, MSBuilt 1968 · S/N 18258876 N42154Datil Fly Inc · Saint Augustine, FLBuilt 1968 · S/N 18258878 N42159Cutruzzula Arthur · Pittsburgh, PABuilt 1968 · S/N 18258881 N4215FBoss Brothers Aviation LLC · Buffalo, MOBuilt 1958 · S/N 46115 N4215UMaynard Paul E · Grand Junction, COBuilt 1964 · S/N 15060215 N4215VTriplett Taran R · Cheyenne, WYBuilt 1948 · S/N 18571 N42164Bush David W · Camden, NCBuilt 1968 · S/N 18258882 N4216LN4216l LLC · Kapolei, HIBuilt 1966 · S/N 17254285 N4216QFoulkrod Freebird LLC · Buda, TXBuilt 1975 · S/N U20603040 N4216UNaeve James M · Renton, WABuilt 1963 · S/N 15060216 N42175Roberts Jason L · Crossville, TNBuilt 1968 · S/N 18258885 N42176N42176 LLC · Lynn Haven, FLBuilt 1968 · S/N 18258886 N42177Skydive Baltimore LLC · Churchville, MDBuilt 1968 · S/N 18258887 N42182Schaible John F · Palmerton, PABuilt 1973 · S/N 18052323 N42184Designed Cabinets · Lakeville, MNBuilt 1968 · S/N 18258890 N42188Verge Gregory J · Lynnwood, WABuilt 1968 · S/N 18258891 N4218FPerry Michael C · Edgewater, FLS/N 46118 N4218LWengs Enterprises Inc · Tustin, CABuilt 1966 · S/N 17254287 N4218QSavant John D · Kinder, LAS/N 17260118 N42198Johnson Steve · Belen, NMBuilt 1968 · S/N 18258894 N4219FHazellief Quillie J Jr · Okeechobee, FLBuilt 1958 · S/N 46119 N4219QAudrain Flying Club Inc · Mexico, MOS/N 17260119 N421CSCrowbar Enterprises LLC · Inola, OKBuilt 2021 · S/N 18283121 N421CVRed-Tailed Hawks Aviation Academy Inc · Mukilteo, WABuilt 1979 · S/N 17272437 N421ERCc Aviation Inc · Tracy, CABuilt 2004 · S/N 172S9679 N421FPJustus Christopher S · Corona, CABuilt 1998 · S/N 17280638 N421FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2004 · S/N 18281495 N421RWPac1 LLC · Clinton, IABuilt 2004 · S/N 172S9593 N421SARedbreast Aviation LLC · Boonton, NJBuilt 2004 · S/N 18281378 N421TWHeslin Jon L · Sutton, MABuilt 1978 · S/N 18266268 N421YKearns Homer C III · Granbury, TXBuilt 1977 · S/N 18266133 N42202Palmer Charles L · Huntington Beach, CAFirst renewal noticeBuilt 1968 · S/N 18258895 N42204Conservation Aviation LLC · Washington, DCBuilt 1968 · S/N 18258897 N42206Jones Brian William · Portland, ORBuilt 1968 · S/N 18258899 N42209Smith Patrick G · Wenatchee, WABuilt 1968 · S/N 18258901 N4220FLeubner Karl T · Marietta, NYS/N 46120 N4220LDelordzia Mark · Columbia, NJBuilt 1966 · S/N 17254289 N4220QWhitefish Aero Services LLC · Crosslake, MNBuilt 1973 · S/N 18502225 N4220VMckinley Jason · Coulterville, ILBuilt 1948 · S/N 18576 N42212Caves Xxi Properties LLC · Virginia Beach, VABuilt 1974 · S/N 17264163 N42219Beck Daniel Joseph · Tuscaloosa, ALBuilt 1968 · S/N 18258908 N4221LSchram Ted K · Mukwonago, WIBuilt 1966 · S/N 17254290 N4221QRegistered aircraftBuilt 1971 · S/N 17260121 N4221UMcwilliams Robert P · Belgrade, MTBuilt 1964 · S/N 15060221 N4221VBashore Barry A · Pleasant Hill, OHBuilt 1948 · S/N 18577 N4222FBelford Zackery U · Elizabethtown, ILBuilt 1958 · S/N 46122 N4222LRtd Aviation LLC · Hillsborough, NJS/N 17254291 N4222QBearlodge Spray Foam & Coatings LLC · Sundance, WYS/N 17260122

Back to AD 79-10-14 R1