Registered aircraft · 56,578

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.

N1836XRodney William Debaun Family Lp · Midlothian, TXBuilt 1964 · S/N 18255936 N1837QHenry Mark S · Endwell, NYBuilt 1971 · S/N 177RG0237 N1838CMcdevitt Daniel C · Social Circle, GABuilt 1953 · S/N 25982 N1838EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12174 N1838MGenesis Aircraft Services Of Martin County LLC · Stuart, FLBuilt 1975 · S/N 18264461 N1838XSkinner Norman D · Osceola, IABuilt 1964 · S/N 18255938 N1838ZAgee Mark L · Greenacres, WABuilt 1962 · S/N 205-0038 N1839COploh Elli M · Makanda, ILBuilt 1953 · S/N 25983 N1839EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12175 N1839FHentz Randy Reuben · Tower City, PABuilt 1966 · S/N 21058739 N1839RBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 18502554 N183CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282342 N183CRBekway Builders LLC · Charleston, SCBuilt 1976 · S/N 18264029 N183ERMustang Sally Aviation LLC · Camden, SCBuilt 1972 · S/N 15073584 N183JPRegistration Pending · Anchorage, AKRegistration pendingS/N 180-52620 N183MERegistration Pending · Page, AZRegistration pendingBuilt 2000 · S/N 20608107 N183NMAfrican Parks Aviation Inc Trustee · Cheyenne, WYS/N 18263646 N183NWNorthwestern Michigan College · Traverse City, MIBuilt 2011 · S/N 172S11083 N183RLJe Air LLC · Bayamon, PRBuilt 1973 · S/N 17261654 N183SKHill Vicki · Saint Joseph, LABuilt 1977 · S/N 18052824 N183SPIndian River Flying Club Inc · Rockledge, FLBuilt 1977 · S/N 172-68675 N184Rocky Mountain Hangars LLC · Longmont, COBuilt 1974 · S/N P3370206 N1840Q6 Cs Air Inc · Tacoma, WABuilt 1971 · S/N 177RG0240 N1840VUnited States Air Force Owner · Apo, APBuilt 1974 · S/N 17263767 N1841QEvolution Electronics LLC · Superior, WIBuilt 1972 · S/N 177RG0241 N1841RPatton Ronald V II · Keizer, ORBuilt 1974 · S/N 18502556 N1841XBoland Thomas · Pewaukee, WIBuilt 1964 · S/N 18255941 N1841YSegroves Chris · Clarkston, WAS/N 17249441 N1842CSmith Ronald Raymond · Willows, CABuilt 1953 · S/N 25986 N1842EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12176 N1842QKrause Douglas S · Davis, CABuilt 1971 · S/N 177RG0242 N1842XRichey Perry A · Willow, AKBuilt 1964 · S/N 18255942 N1842ZVermont Skydiving Adventures Inc · Bristol, VTBuilt 1962 · S/N 205-0042 N1843FJordan Jay · Centre, ALBuilt 1966 · S/N 21058743 N1843QJohnson Dana J · Winona, MNBuilt 1972 · S/N 177RG0243 N1843ZVacek George T Jr · Anchorage, AKBuilt 1962 · S/N 205-0043 N1844QT & E Brothers Inc · Gardena, CABuilt 1972 · S/N 177RG0244 N1844XSmith James E · Cuba, MOBuilt 1964 · S/N 18255944 N1844ZN1844z LLC · Hillsboro, ORBuilt 1962 · S/N 205-0044 N1845FJones Sandy Ray · Williamsburg, NMS/N 21058745 N1845VSkypark Inc · Wadsworth, OHBuilt 1974 · S/N 17263769 N1845XFry Richard R · Marana, AZBuilt 1965 · S/N 18255945 N1845YAlpha Aviation Holdings Group LLC · Raleigh, NCBuilt 1962 · S/N 17249445 N1845ZQuale Scott M · New Town, NDBuilt 1978 · S/N 180-52973 N1846CNorthwest Intl Aviation · Seattle, WABuilt 1953 · S/N 25990 N1846QBucciarelli Tazio E · San Diego, CABuilt 1972 · S/N 177RG0246 N1846YMuldoon Anthony P · Howell, MIS/N 17249446 N1846ZFullerton Thomas M · Centennial, COBuilt 1978 · S/N 180-52968 N1847QDye Michael M · Bastrop, TXBuilt 1972 · S/N 177RG0247 N1847RNugent Properties LLC · Wasilla, AKFirst renewal noticeBuilt 1974 · S/N 18502562

Back to AD 79-10-14 R1