Registered aircraft · 20,483

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.

N2431QWade Consulting LLC · Aviston, ILBuilt 2000 · S/N 18280684 N2431VAamodt Arne E · Soldotna, AKS/N 20608093 N2432CFreed Richard H · Watervliet, MIBuilt 1954 · S/N 30732 N2432QJohnson Carl H · Northstreet, MIBuilt 1968 · S/N 18258632 N2432RLindsley Daniel · Vulcan, MIS/N 18255532 N2432XVickers Ryan P Trustee · Tarpon Springs, FLBuilt 1965 · S/N 18256332 N24337Dunn Craig M · Sarasota, FLBuilt 2000 · S/N 18280713 N2433DDh Communications Inc · Blairsville, GABuilt 1979 · S/N 18266967 N2433EElco Electric · Bangor, MEBuilt 2000 · S/N 20608136 N2433GHunt George P · Kamiah, IDBuilt 1959 · S/N 51733 N2433RRohrer Walter J · Gallatin, TNS/N 18255533 N2434CGoad Graham L · Mcminnville, ORBuilt 1954 · S/N 30734 N2434FHanson Inc · Kalispell, MTS/N 18051634 N2434XJensen Shaun V · Anchorage, AKBuilt 1965 · S/N 18256334 N2434YRegistration Pending · Cedar Falls, IARegistration pendingBuilt 2000 · S/N 20608078 N2435CAzure Skies LLC · Bloomington, INBuilt 1999 · S/N 18280644 N2435FBas Part Sales LLC · Greeley, COS/N 180-51635 N2435GVoninski John R · Manlius, NYS/N 51735 N2435QVolare Aviation LLC · Wylie, TXBuilt 1966 · S/N 18257635 N2436CHawk Unlimited LLC · Kalispell, MTS/N 30736 N2436GDk Futures LLC · Reno, NVBuilt 1959 · S/N 51736 N2436RSilva Gary · Yerington, NVBuilt 1964 · S/N 18255536 N2436VGt Holdings LLC · Nashville, TNBuilt 2006 · S/N 18281786 N24376C R Transport Inc · Wilmington, DEBuilt 2000 · S/N 18280704 N2437CFogleman Brian L · Stonewall, LAS/N 30737 N2437FKuersten Robert S · Middleton, WIBuilt 1965 · S/N 18051637 N2437LLean Enterprises Inc · Brookhaven, MSBuilt 2006 · S/N 18281791 N2437RBlackwelder John W · Columbia, KYBuilt 1964 · S/N 18255537 N2437UPlanetosea LLC · Doylestown, PABuilt 1983 · S/N 21064782 N2437WAllen Larry D · Bellingham, WAS/N 18280705 N2437XLudke Arnold · Oakland, NJBuilt 1965 · S/N 18256337 N24389Way Of The Lord LLC · London, KYBuilt 2000 · S/N 18280708 N2438AHorse Creek 3518 Inc · Hollywood, FLBuilt 2006 · S/N 18281793 N2438FMackie Scott Christopher · Elkton, MDBuilt 2006 · S/N 18281794 N2438GWk Aviation LLC · Buffalo, SDBuilt 1959 · S/N 51738 N2438XRousser Cattle LLC · Amarillo, TXBuilt 1965 · S/N 18256338 N2439BVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N 18280955 N2439C206 Aircraft Leasing Co Inc · Marathon, FLBuilt 2000 · S/N 20608100 N2439GJ+J Electric LLC · Seminole, TXBuilt 1959 · S/N 51739 N2439TSkylane 2439t Partners LLC · Burlingame, CABuilt 2000 · S/N 18280810 N2439XAlpha Aero LLC · Biddle, MTBuilt 1965 · S/N 18256339 N243MEMcaleer William V Jr · Milledgeville, GABuilt 2000 · S/N 20608113 N243RZBest Aircraft Deals LLC · Salt Lake City, UTBuilt 1983 · S/N 21064961 N2440QTeanaway Ventures Consulting LLC · Cle Elum, WABuilt 2001 · S/N 18280937 N2441RBelly Acres Capital And Management LLC · Memphis, TNBuilt 1964 · S/N 18255541 N2441SSzpara John V Trustee · Chesnee, SCBuilt 1976 · S/N 21061284 N2441XPippy LLC · Naples, FLBuilt 2006 · S/N 18281802 N24429Pniak Robert J · Carmel Valley, CABuilt 2000 · S/N 18280700 N2442CRoberts Calvin · Bluebell, UTBuilt 1954 · S/N 30742 N2442GRegistration Pending · King Salmon, AKRegistration pendingBuilt 1959 · S/N 51742

Back to AD 84-10-01 R1