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.

N426LPAir Mates Flying Club Inc · Northfield, NJBuilt 1999 · S/N 172S8199 N426MBTimothy Harty · New Richmond, WIBuilt 1984 · S/N 18504420 N426MCMagic Carpet LLC · Wilmington, DEBuilt 1971 · S/N 17260022 N426PWElectron International Aviation LLC · Phoenix, AZBuilt 2020 · S/N 18283111 N426RBChristiansen Aviation LLC · Wilmington, DEBuilt 2011 · S/N 172S11134 N426SKBergstrom Aircraft Inc · Pasco, WABuilt 1979 · S/N 17273720 N426XARound Engine Aero · Nashville, MIS/N 15063198 N42700Van Matre Thomas A Jr · Mineola, TXBuilt 1973 · S/N 18052371 N42704White Dog I LLC · Bend, ORBuilt 1968 · S/N 18259149 N42705Henry James A · Fresno, CABuilt 1968 · S/N 18259150 N42707Management Assistance Group LLC · Hamilton, NJBuilt 1968 · S/N 18259152 N4270LDavenport Sam · Gail, TXBuilt 1966 · S/N 17254339 N4270QReeves James C · Locust Grove, GABuilt 1971 · S/N 17260170 N4270USilvia Scott A · Valley Springs, CAS/N 15060270 N42712Adams William Kelly · Tulia, TXBuilt 1968 · S/N 18259155 N42713Prater Bobby D · Grand Ledge, MIBuilt 1968 · S/N 18259156 N42714Crouch Jeffrey Lane Sr · Rockingham, NCBuilt 1968 · S/N 18259157 N42715Coleman Robert B · San Francisco, CABuilt 1968 · S/N 18259158 N42718Circle K Bar LLC · Ardmore, OKBuilt 1968 · S/N 18259161 N4271FStevens George C · Lake Leelanau, MIBuilt 1958 · S/N 46171 N4271LRoberts David W · Arden, NCS/N 17254340 N42725Tepper Jeremy A · Vail, AZBuilt 1968 · S/N 18259165 N4272FCayton John C · Cameron, MOS/N 46172 N4272LStechbart Kurt E · Glendora, CABuilt 1966 · S/N 17254341 N4272QKeech Mark A · Fairbanks, AKBuilt 1976 · S/N U20603042 N4272VShaw Christopher · Porterville, CAFirst renewal noticeBuilt 1948 · S/N 18630 N42732Wampole David R · Miami, FLBuilt 1968 · S/N 18259169 N4273FVan Wychen James G · Warrens, WIBuilt 1958 · S/N 46173 N4273QSimmons Robert J · Justin, TXBuilt 1971 · S/N 17260173 N4273RYuknis Leonard F · Wasilla, AKBuilt 1976 · S/N 18502924 N4273ULykens Valley Aviation · Lykens, PABuilt 1963 · S/N 15060273 N42742Still Russell F · Cumming, GABuilt 1968 · S/N 18259171 N42748Crowe Tanner L · Anchorage, AKBuilt 1968 · S/N 18259173 N4274FAppalachian Bible College Inc · Mount Hope, WVS/N 46174 N4274QLjn Aircraft LLC · Jamestown, NYBuilt 1971 · S/N 17260174 N4274RCatset Funding LLC · Coral Gables, FLBuilt 1997 · S/N 18280027 N42754Shade Donald S · Big Bear City, CABuilt 1968 · S/N 18259175 N42758Carver Steven R · Scottsville, KYS/N 18259177 N4275FG & M Associates LLC · Quitman, GAS/N 46175 N4275LBarney Jared L · Tully, NYBuilt 1966 · S/N 17254344 N42763Vf 126 Aviation LLC · Chicago, ILBuilt 1968 · S/N 18259178 N427653 B Farms Inc · Pinetown, NCBuilt 1968 · S/N 18259180 N42766Jessee Robert A · Winter Haven, FLBuilt 1968 · S/N 18259181 N42768Horn Terry D · Sharpsburg, GAS/N 18259183 N4276QOjdrovich George · Steamboat Springs, COBuilt 1971 · S/N 17260176 N42770Barthelette Kenneth E · Pawleys Island, SCBuilt 1968 · S/N 18259184 N42777Cantwell Patrick W · San Francisco, CABuilt 1968 · S/N 18259185 N4277BHale Barbara M · Oxnard, CABuilt 1977 · S/N R1722556 N4277FMilitary And Civilian Aviation Heritage Foundation · Benton, PABuilt 1958 · S/N 46177 N4277QRawlins William David Sr · Martinez, GABuilt 1971 · S/N 17260177

Back to AD 79-10-14 R1