Skip to content

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.

N455EDTurner James Glenn · Naples, FLBuilt 1962 · S/N 21058118 N455GBBrs Leasing Inc · Wilmington, DEBuilt 1982 · S/N 15285455 N455WCHayes William F · Perrysburg, OHBuilt 1969 · S/N 337-1191 N45601Three Four Juliet LLC · Orange, CABuilt 1975 · S/N 15076986 N45613Devanani Vishnu D · Orlando, FLS/N 15076988 N45614Gard Lionel V III · Camp Wood, TXBuilt 1975 · S/N 15076989 N45617Schumaker Grant E · Wichita, KSBuilt 1975 · S/N 15076991 N4561VOrca Wealth Management LLC · New Port Richey, FLBuilt 1976 · S/N U20603052 N45623Prosperous Holdings LLC · Gainesville, GABuilt 1975 · S/N 15076994 N45626Creamer James P · Lakeland, FLBuilt 1975 · S/N 15076997 N4562FMcdaniel Dean K · Queen Creek, AZS/N 185-1069 N45632Marble Jere D · Dayton, NVBuilt 1975 · S/N 15076998 N45636Carolina Tripacers LLC · Summerville, SCBuilt 1975 · S/N 15076999 N4563BLarose Gary R · Anchorage, AKS/N 31462 N4563CBrown Peter D · Anchorage, AKBuilt 1953 · S/N 25507 N4563UBailey Wesley S · Bulverde, TXBuilt 1964 · S/N 15060563 N4563WE&V Air LLC · Chatsworth, GABuilt 1973 · S/N 18262363 N45649Cygan Fred P · Hudson, MABuilt 1975 · S/N 15077006 N4564CMountain Todd Lee · Byron, MIBuilt 1953 · S/N 25508 N45659Mcallister Christopher E · Phoenix, AZBuilt 1975 · S/N 15077011 N45662Turnberry Air LLC · Oviedo, FLBuilt 1975 · S/N 15077012 N45663Williams Kaylee A · Grapevine, TXBuilt 1975 · S/N 15077013 N4566BWagnon Bertram L · Anchorage, AKS/N 31465 N4566UGruver Norval T · Bartlesville, OKBuilt 1964 · S/N 15060566 N45673Theimer Ryan D · West Bend, WIS/N 15077015 N45677Davidson Christopher Scott · Friant, CABuilt 1977 · S/N 177RG1126 N4567BCavu LLC · Boise, IDBuilt 1955 · S/N 31466 N4567FPatterson Roland O · Semmes, ALBuilt 1960 · S/N 57314 N4567GKris Noone Air LLC · Wilmington, DEBuilt 1965 · S/N 337-0110 N4567UWaits Kerry S · Red Bluff, CAS/N 15060567 N4568CYorde Roger C · North Fort Myers, FLBuilt 1963 · S/N 21058142 N4568FWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282989 N45693Wingnut Aviation LLC · Johnson City, TNBuilt 1975 · S/N 15077022 N45699Jej Leasing LLC · Bangor, MEBuilt 1975 · S/N 15077025 N4569CReese Brandon A · Bend, ORS/N 25423 N456BHCastleton Real Estate & Developlment Inc · El Monte, CAS/N R18201482 N456BRPressurized LLC · Sequim, WAFirst renewal noticeBuilt 1981 · S/N P21000717 N456BWCustom Wholesale Supply Co Inc · Odessa, TXBuilt 1975 · S/N 20700298 N456CBCollins Bruce H · Caldwell, TXBuilt 1968 · S/N 17257257 N456CRMcevoy Richard D Trustee · Anchorage, AKBuilt 1977 · S/N R1722756 N456CWSale Reported · Fort Denaud, FLSale reportedBuilt 1982 · S/N 21064676 N456DHWilliams Metal And Machinery LLC · Irvington, ALS/N 21058042 N456DJSingle Raj Pa Inc · Seattle, WABuilt 1982 · S/N R18201888 N456JGGronemeyer Jens · Deland, FLS/N 18264380 N456MADean Insurance Agency Inc · Crockett, TXS/N U20604325 N456WDMinton Mark D · Mobile, ALBuilt 1973 · S/N 15075169 N456WFStevenson William Gary · Creswell, ORBuilt 1949 · S/N 18903 N45700Fritsch Raymond H · Galesville, WIBuilt 1975 · S/N 15077026 N45705Shaikh Khizer · Lake Havasu City, AZBuilt 1975 · S/N 15077027 N4570CFairbanks Investor LLC · Fairbanks, AKBuilt 1956 · S/N 25514

Back to AD 87-20-03 R2