Registered aircraft · 54,017

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N3180QA & L Aircraft Holding LLC · Miami Springs, FLBuilt 1967 · S/N 18258180 N3180RThomas Lance E Trustee · Mesa, AZBuilt 1967 · S/N 18258580 N3180UBasan Oasis LLC · Santa Teresa, NMBuilt 1963 · S/N 18254580 N3180YWalker Jim · Lovell, WYBuilt 1962 · S/N 18254180 N3181CFour Boys Aviation LLC · Madison, MSFirst renewal noticeBuilt 1954 · S/N 30980 N3181SWood David M · Purcellville, VABuilt 1964 · S/N 18255681 N3181TDuck Donald S · Edwardsburg, MIBuilt 1967 · S/N 17700481 N3181XHart George · Roseville, CABuilt 1966 · S/N 15064581 N3182DHanft Thomas A · Oakhurst, CABuilt 1955 · S/N 31980 N3182QMagnusson Ralph L · Wyoming, MNBuilt 1967 · S/N 18258182 N3182RSeven Hills Sky Divers Inc · Madison, WIBuilt 1967 · S/N 18258582 N3182SRyan Aviation Management LLC · Palm Coast, FLBuilt 1964 · S/N 18255646 N3182UGarcia-Martinez Jose Victor · Birmingham, ALBuilt 1963 · S/N 18254582 N3182XHerrera Lizann · Sumner, WABuilt 1966 · S/N 15064582 N3182YHeckethorn Philipp · Baker, NVBuilt 1962 · S/N 18254182 N3183CWide Open Aviation LLC · Kennewick, WABuilt 1978 · S/N R18200251 N3183DT2k Aircraft · Austin, TXBuilt 1955 · S/N 31981 N3183JRank Brian Andrew · Oxford, MIBuilt 1966 · S/N 15065883 N3183QMj Syndicate LLC · Vancouver, WAS/N 18258183 N3183RRusso Anthony G · Melbourne Beach, FLS/N 18258583 N3183SJohnson Richard · Winnebago, MNBuilt 1964 · S/N 18255683 N3183XTrimble John Sr · Stone Mountain, GABuilt 1966 · S/N 15064583 N3183YAlc Aviation LLC · Milwaukee, WIBuilt 1962 · S/N 18254183 N3184BCerisano Kevin · Trussville, ALBuilt 1952 · S/N 25426 N3184DRitchie Rex W · Lopez Island, WABuilt 1955 · S/N 31982 N3184QBeaugh Anthony H · Platteville, COBuilt 1967 · S/N 18258184 N3184RGardner Daniel J · Alvord, TXBuilt 1967 · S/N 18258584 N3184SThrash Farms Inc · Pelahatchie, MSBuilt 1964 · S/N 18255684 N3184XSandlapper Aviation Of De · Bennington, VTBuilt 1966 · S/N 15064584 N3184YFunkhouser David E · Weatherford, OKBuilt 1962 · S/N 18254184 N3185BThomas Coby M · Fairbanks, AKBuilt 1953 · S/N 25427 N3185DMorgan Douglas C · Anchorage, AKBuilt 1955 · S/N 31983 N3185F85 Foxtrot LLC · Redmond, ORS/N 18257285 N3185QPara Tactics LLC · Shelton, WABuilt 1967 · S/N 18258185 N3185XSanders John L · Sikeston, MOS/N 15064585 N3185YGochenour Air Inc · Fort Wayne, INBuilt 1962 · S/N 18254185 N3186DSutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 31984 N3186JHowenstein John G · Roseville, CABuilt 1966 · S/N 15065886 N3186QKimbril Steve · Hartselle, ALBuilt 1967 · S/N 18258186 N3186RHuey Gale R · Celeste, TXBuilt 1967 · S/N 18258586 N3186XPanus Mark V · Hinsdale, NYBuilt 1966 · S/N 15064586 N3186YJram Air Parts LLC · Henderson, NVBuilt 1962 · S/N 18254186 N3187BRitchie Robert E · Centennial, COBuilt 1953 · S/N 25429 N3187CHemm Colby L · Newcastle, CABuilt 1954 · S/N 30986 N3187FVolatile Aero Ventures LLC · Boulder City, NVBuilt 1966 · S/N 18257287 N3187JBrar Amuldeep S · Austin, TXBuilt 1966 · S/N 15065887 N3187UMillikan Kimball S · Honolulu, HIBuilt 1963 · S/N 18254587 N3187YMiller Richard G · Anson, TXS/N 18254187 N3188AReints Rydell J · Wasilla, AKBuilt 1953 · S/N 25832 N3188JFlight Time Builders Inc · Memphis, TNBuilt 1966 · S/N 15065888

Back to AD 87-20-03 R2