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.

N4717CCt Aviation LLC · Fort Worth, TXBuilt 1979 · S/N 21063598 N4717NHaagenson Jeffrey M · Portland, ORS/N 18267306 N47189Xclusive Level Aircraft World LLC · Kissimmee, FLS/N 15283183 N4718AQuinby Gary D Trustee · Ardmore, OKBuilt 1979 · S/N A1520880 N4718BMartin Nathaniel W Trustee · Wasilla, AKBuilt 1955 · S/N 31616 N4718DAviation Of North Florida LLC · Jacksonville, FLBuilt 1958 · S/N 34818 N4718FPbar Inc · Joseph, ORBuilt 1966 · S/N P206-0318 N4718KMayes John · Carson City, NVS/N R1722017 N4718NL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 1979 · S/N 18267307 N4718XRobb James W · Uhrichsville, OHBuilt 1966 · S/N 15064768 N47193Cloud Dancer Aviation Inc · Deland, FLBuilt 1979 · S/N 15283185 N4719FFrederick Joel · Hobe Sound, FLBuilt 1979 · S/N 17273076 N4719KOneninekilo LLC · West Linn, ORBuilt 1975 · S/N 18263718 N4719TOchoa Ricardo · Douglas, AZS/N R18201742 N471BCHyndman Antonio · Canton, TXBuilt 1976 · S/N 18264591 N471GMHarland Willard G · Tuscumbia, ALBuilt 1979 · S/N R18201112 N471JROrtiz Rivera Jose E · Bayamon, PRBuilt 1972 · S/N 17260933 N471PRRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1973 · S/N 17262016 N472Custer Charles D · Destin, FLS/N 205-0476 N4720BAffiliated Air Services Inc · Vincentown, NJBuilt 1979 · S/N 15283596 N4720CNesbit Gary M · West Linn, ORBuilt 1979 · S/N 21063601 N4720KGeorge Joseph Q · Granbury, TXBuilt 1975 · S/N 18263719 N4720PKlingler Larry R · Wolfeboro, NHBuilt 1978 · S/N P21000090 N4720QFielding William J IV · Scarborough, MES/N 185-1174 N4720RHotkeys Holding LLC · Silver Spring, MDBuilt 1979 · S/N 172RG0016 N4720YKraemair Aviation LLC · Sauk City, WIBuilt 1980 · S/N 21063992 N4721BEuro 2000 Inc · Merritt Island, FLBuilt 1979 · S/N 15283597 N4721DCarm'S LLC · Beaver Springs, PAS/N 34821 N4721NRegistered aircraftBuilt 1979 · S/N 18267310 N4721QXtreme Attitudes LLC · Sanford, NCBuilt 1966 · S/N 185-1175 N4721RWaterdawg Express LLC · Pocatello, IDBuilt 1979 · S/N 172RG0017 N4721UBartlow Amos · North Pole, AKBuilt 1964 · S/N 18051421 N4722BHill James P · Eagle Point, ORBuilt 1955 · S/N 31620 N4722FStoskopf Scott W · El Dorado, KSBuilt 1966 · S/N P206-0322 N4722UBlackmon Peter G · Anchorage, AKS/N 18051422 N4723BEuro 2000 Inc · Merritt Island, FLBuilt 1979 · S/N 15283598 N4723FStraightin LLC · Paauilo, HIBuilt 1966 · S/N P206-0323 N4723NNorth Central Aircraft LLC · Blaine, MNBuilt 1979 · S/N 18267312 N4723PChristiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 15284804 N4723RSmolkin Alexander S · North Chesterfield, VABuilt 1979 · S/N 172RG0018 N4723TPrs Holdings Inc · Jurupa Valley, CABuilt 1981 · S/N R18201744 N4723YRegina Air Cargo Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 21063993 N47249Farnsworth Erwin L · Anchorage, AKBuilt 1959 · S/N 50464 N4724BSchlink Richard L · Soulsbyville, CABuilt 1955 · S/N 31622 N4724KWalgrove Venice LLC · Santa Monica, CABuilt 1975 · S/N 18263723 N4724QDehart T James Trustee · Kalama, WABuilt 1978 · S/N 18503550 N4724XFlying My Dreams LLC · Miami Gardens, FLS/N 15064774 N47253De Wan Madisun Nicole · Tarpon Springs, FLBuilt 1979 · S/N 15283198 N4725CContinental Aerospace Technologies Inc · Mobile, ALBuilt 1982 · S/N T30300118 N4725DClover Park Technical College · Tacoma, WABuilt 1979 · S/N 17272340

Back to AD 87-20-03 R2