Registered aircraft · 54,015

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.

N7138SDeaton Craig · West Alexandria, OHBuilt 1967 · S/N 15067838 N7138THudson Thomas C · Bessemer, ALBuilt 1959 · S/N 46738 N7138XHalvorson Jerome B · Wyndmere, NDBuilt 1961 · S/N 15059238 N71397Turner Chris · Kosse, TXBuilt 1969 · S/N 18259606 N71398Koch Jon P · Menahga, MNBuilt 1969 · S/N 18259607 N7139ATimothy Scott Bloom · Chugiak, AKBuilt 1956 · S/N 29239 N7139EBarnes Gary · Idaho City, IDBuilt 1959 · S/N 52139 N7139GSkysg LLC · Eugene, ORBuilt 1969 · S/N 17258839 N7139QFernander David · Enterprise, ALBuilt 1972 · S/N 17260439 N7139TPhilpot John Michael · Liberty, MOS/N R18200025 N713ADSchuessler William · Turner, ORBuilt 1975 · S/N 18264339 N713BJRiley James A · Richmond, KYBuilt 1959 · S/N 46696 N713BMMathieu Robert B · Delhi, LABuilt 1980 · S/N R18201453 N713DJimmy & Steve Aviation LLC · Fredericksburg, VABuilt 1973 · S/N 18262519 N713GFFleming Geoffrey R Jr · Port Saint Lucie, FLBuilt 1975 · S/N 18263999 N713JKSbarounis Carl A · Torrance, CABuilt 1975 · S/N 17265460 N713KRegistered aircraftBuilt 1975 · S/N 18263804 N713MATraining Wheels & Advanced Technologies LLC · La Salle, COBuilt 1966 · S/N U206-0679 N713SJKoerner James L Trustee · Gilbert, AZBuilt 1977 · S/N 17269713 N713SMJa Williams Investments LLC · Austin, TXBuilt 1969 · S/N 18259920 N713TGSelway Construction Group LLC · Moscow, IDBuilt 1979 · S/N U20605218 N714United States Department Of Interior · Boise, IDBuilt 1975 · S/N 18502711 N71400Wubben Robert C · Waupaca, WIBuilt 1969 · S/N 18259609 N71405Bowes John Michael · Lake City, FLBuilt 1969 · S/N 18259611 N71408Emerald Darin · Springerville, AZBuilt 1969 · S/N 18259612 N71409Piedmont Flight Inc · Winston Salem, NCBuilt 1976 · S/N 17267227 N7140BEstep James B · Chillicothe, OHBuilt 1977 · S/N A1520740 N7140EJ W Bamford Inc · Oroville, CABuilt 1959 · S/N 52140 N7140FLogan Gregory A · Chouteau, OKS/N 15063740 N7140JCohesive Aviation LLC · Gilford, NHBuilt 1980 · S/N 17273901 N7140QMagnuson Jessica M · Olathe, KSBuilt 1972 · S/N 17260440 N7140SRegistration Pending · Bermuda Dunes, CARegistration pendingBuilt 1976 · S/N 18265069 N7140TMurray Robert S Trustee · Shingle Springs, CABuilt 1977 · S/N R18200026 N7141AFarruggia John A · West Winfield, NYBuilt 1956 · S/N 29241 N7141EBobek Janice C · Soldotna, AKBuilt 1959 · S/N 52141 N7141GDyke Paul A · Hartford, SDBuilt 1969 · S/N 17258841 N7141JHutt Aviation Inc · Minden, NVS/N 17273902 N7141QFlight Time Builders Inc · Memphis, TNBuilt 1972 · S/N 17260441 N7141TRosser David S · Lynn, ALBuilt 1959 · S/N 46741 N7141XWells Brent R · Atascadero, CABuilt 1961 · S/N 15059241 N71420Yeti Aviations LLC · Madison, ALBuilt 1969 · S/N 18259616 N7142EDuncan Wayne K Trustee · Athol, IDBuilt 1959 · S/N 52142 N7142QObymachow Richard M · Killingworth, CTS/N 17260442 N7142XTownsend Charles D · Portage, MIBuilt 1961 · S/N 15059242 N71430Princeton Raptors Flying Club · Princeton, MNS/N 17263380 N7143EPfisters Flying Wahine LLC · Waialua, HIBuilt 1959 · S/N 52143 N7143GAllen Nathanael W · Bemidji, MNBuilt 1969 · S/N 17258843 N7143MMiles Richard B · Lompoc, CABuilt 1958 · S/N 55443 N7143QMcgraw Warren R · Pineville, WVBuilt 1973 · S/N 18262036 N71444Rushville Flying Club Inc · Rushville, ILBuilt 1975 · S/N 172-65662

Back to AD 87-20-03 R2