Skip to content

Registered aircraft · 20,484

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N182YHParker Nicholas · St Maries, IDBuilt 1965 · S/N 18256349 N182YSYuba-Sutter Aviation Inc · Olivehurst, CABuilt 1963 · S/N 18254845 N182YYForrest C Cranfill Construction Co · Shallotte, NCS/N 18280340 N182YZSouthern Latitude LLC · Alabaster, ALBuilt 1998 · S/N 18280198 N182ZMUnerti Michael J · Mosinee, WIBuilt 1969 · S/N 18260033 N182ZTTurner & Co Inc · West Richland, WABuilt 1968 · S/N 18258910 N182ZXSky Texas Aerospace LLC · Melissa, TXBuilt 1957 · S/N 34111 N182ZZBurke Paul A · Rogersville, TNBuilt 1967 · S/N 18258564 N1830XManoogian Vrej K · Eustis, FLBuilt 1964 · S/N 18255930 N1831XMorelli Milo M · Seattle, WABuilt 1964 · S/N 18255931 N1832XWagner Sheila R · West Chester, PABuilt 1964 · S/N 18255932 N1833FHale Jay · Corpus Christi, TXS/N 21058733 N1833XMulliner Richard L · Phoenix, AZBuilt 1964 · S/N 18255933 N1833ZEastwood Gregory S · Red Oak, TXBuilt 1962 · S/N 205-0033 N1834QStrohmeyer Gregory Charles · Wasilla, AKBuilt 1975 · S/N U20602941 N1834RRadford David M · Glen Cove, NYBuilt 1978 · S/N R18200575 N1834XPiro Byron · Coeur D Alene, IDBuilt 1964 · S/N 18255934 N1835MAanonsen Lloyd B · Venice, FLBuilt 1975 · S/N 18264459 N1835XConfluencia Leasing LLC · Independence, MOBuilt 1964 · S/N 18255935 N1835ZRegistered aircraftBuilt 1962 · S/N 205-0035 N1836MCallan Donald G · Yulee, FLS/N 18264460 N1836XRodney William Debaun Family Lp · Midlothian, TXBuilt 1964 · S/N 18255936 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 N1839FHentz Randy Reuben · Tower City, PABuilt 1966 · S/N 21058739 N183BBRussell Charles B DBA · Union City, TNBuilt 1978 · S/N R18200310 N183CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282342 N183CRBekway Builders LLC · Charleston, SCBuilt 1976 · S/N 18264029 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 N183SKHill Vicki · Saint Joseph, LABuilt 1977 · S/N 18052824 N1841XBoland Thomas · Pewaukee, WIBuilt 1964 · S/N 18255941 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 N1843ZVacek George T Jr · Anchorage, AKBuilt 1962 · S/N 205-0043 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 N1845XFry Richard R · Marana, AZBuilt 1965 · S/N 18255945 N1845ZQuale Scott M · New Town, NDBuilt 1978 · S/N 180-52973 N1846ZFullerton Thomas M · Centennial, COBuilt 1978 · S/N 180-52968 N1848ZBritt Robert J · Augres, MIBuilt 1962 · S/N 205-0048 N1849FCrouse William F · Priest River, IDBuilt 1966 · S/N 21058749 N1849XRaymond Patrick H · Jerseyville, ILBuilt 1965 · S/N 18255949 N184AKDe Man Cameron T · Bend, ORBuilt 1963 · S/N 18051302 N184CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 18283259 N184CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282174

Back to AD 84-10-01 R1