Skip to content

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.

N7375GAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1970 · S/N 17259075 N7375NEllison Air Inc · Anchorage, AKS/N U20603641 N7375QFort Sam Houston Flying Club · San Antonio, TXBuilt 1972 · S/N 18261015 N7375SSutherland Joan Ellen · Richmond, VABuilt 1976 · S/N 18265166 N7375TMclean Robert M · Baltimore, MDBuilt 1959 · S/N 46975 N7375XBluewater Airmotive Corp · Wilmington, DEBuilt 1961 · S/N 15059475 N73761Spring City Aviation Inc · Waukesha, WIBuilt 1976 · S/N 17267658 N73764White David W · Woodland, WAS/N 17267661 N73768Flighttime Inc · Wiscasset, MEBuilt 1976 · S/N 17267664 N73769Canino Enterprises Inc · Miami, FLBuilt 1976 · S/N 17267665 N7376HMph Aviation LLC · Toccoa, GABuilt 1981 · S/N 18267912 N7376NSale Reported · Bloomburg, TXSale reportedBuilt 1974 · S/N 18263159 N7376QThompson Christopher John · Odessa, FLBuilt 1972 · S/N 18261016 N7376TClee Jacob M · Chickamauga, GABuilt 1959 · S/N 46976 N7376XGuarino Jack Aubrey · Mobile, ALS/N 15059476 N73776Seebold Jdustin K · Mifflinburg, PABuilt 1976 · S/N 17267670 N7377ARfk Aerospace LLC · Clayton, NCS/N 29477 N7377HProcaccini Donald Jr · Spring Hill, FLBuilt 1977 · S/N 18503382 N7377QKnights Aviation LLC · Cuyahoga Falls, OHBuilt 1972 · S/N 18261017 N7377TRock Nh Services LLC · Alpine, TXS/N 46977 N73784Dsr Cherokee 180 LLC · Dallas, TXBuilt 1976 · S/N 17267676 N73785Sierra Sky Aviation LLC · Whitefish, MTBuilt 1976 · S/N 17267677 N73786Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267678 N73787Pegasus Flying Club LLC · Mccordsville, INS/N 17267679 N73789Ryan Air Inc · Anchorage, AKBuilt 1980 · S/N 20700629 N7378MArmstrong Bruce · Port Orchard, WABuilt 1958 · S/N 55678 N7378NWhitmarsh Stephen C · Marysville, CABuilt 1974 · S/N 18263161 N7378XHartman Dave L · Barrett, MNBuilt 1961 · S/N 15059478 N73790Jimenez Carlos A · Davie, FLBuilt 1976 · S/N 17267682 N73798Lowry Steve · Sun River, MTBuilt 1976 · S/N 17267688 N73799Sojak Therin F · Harlingen, TXBuilt 1976 · S/N 17267689 N7379ANguyen Tuong · Henderson, NVBuilt 1956 · S/N 29479 N7379KSmith Zachary M · Woodworth, LABuilt 1976 · S/N R1722066 N7379QVolair Lineas Aereas Del Caribe Sa LLC · Tamarac, FLBuilt 1972 · S/N 18261019 N7379S818 Flyers LLC · La Crescenta, CABuilt 1976 · S/N 18265170 N7379TPaulino Junior · Poughkeepsie, NYBuilt 1959 · S/N 46979 N7379UIliamna Air Taxi Inc · Iliamna, AKBuilt 1978 · S/N 20700427 N737AAHogan Thomas A · Fairfield, OHBuilt 1977 · S/N 17269258 N737ABBellingham Aviation Services LLC · Bellingham, WAS/N 17269259 N737ACU56fliers LLC · Idaho Falls, IDBuilt 1977 · S/N 17269260 N737AEBluewater Airmotive Corp · Wilmington, DEBuilt 1977 · S/N 17269262 N737AFApm Leasing LLC · Casper, WYS/N 17269263 N737ALRegistration Pending · Homer, AKRegistration pendingBuilt 1977 · S/N 17269268 N737AMCalifornia Aviation Services Inc · Riverside, CABuilt 1977 · S/N 17269269 N737AQDebalco Enterprises Inc DBA · Colorado Springs, COBuilt 1978 · S/N R18200814 N737AWFinland Leasing Co Inc · Quakertown, PABuilt 1977 · S/N 17269277 N737AYMoeller Dakota J · West Point, IABuilt 1977 · S/N 17269279 N737BAFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1977 · S/N 17269281 N737BBHaughey Mathew · Celebration, FLBuilt 1977 · S/N 17269282 N737BCN737bc LLC · Dover, DEBuilt 1977 · S/N 17269283

Back to AD 87-20-03 R2