Skip to content

Registered aircraft · 54,016

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.

N1143FWilson Dan · Saginaw, TXS/N 17254738 N1143MCastelletti Mark Anthony Trustee · Casa Grande, AZBuilt 1970 · S/N 17259443 N11442Burkholder Donald R · Kent, OHS/N 15075424 N1144FBandit Air LLC · Stowe, PABuilt 1956 · S/N 33279 N1144MCcr Aviation LLC · Kalispell, MTS/N 17259444 N1144YThomas Douten D · Roxbury, MES/N 15059544 N11452Schatz Michael J · Myerstown, PABuilt 1973 · S/N 15075433 N11454Wausau Flying Service Inc · Wausau, WIBuilt 1973 · S/N 15075434 N1145FGurke George J · Anchorage, AKBuilt 1975 · S/N 18502757 N11460Kalmar Peter · Suquamish, WABuilt 1973 · S/N 15075439 N1146FLarson Larry D · Sargeant, MNBuilt 1966 · S/N 17254741 N1146MMitchell Kenneth A · Uniontown, PABuilt 1972 · S/N 33701446 N11476Shannon Kenneth H · Washington, DCBuilt 1975 · S/N 17702340 N11479Lucky Duck Aviation LLC · Palm City, FLBuilt 1973 · S/N 15075450 N1147FParker Robert M · Hurst, TXBuilt 1966 · S/N 17254742 N1147VRegistration Pending · Moore, OKRegistration pendingBuilt 1976 · S/N R1722122 N11485Foster Harold · Natchitoches, LABuilt 1973 · S/N 15075453 N11488Cooker Keith P · Greenville, SCBuilt 1973 · S/N 15075456 N1148FReed Roger · Lebanon, KYBuilt 1966 · S/N 17254743 N11491Jamieson Donald R · Condon, ORS/N 15075458 N11492Mccroan James H · Altha, FLBuilt 1973 · S/N 15075459 N11493Wajih Al Habbal · Simi Valley, CABuilt 1973 · S/N 15075460 N1149911499 LLC · Oklahoma City, OKS/N 15075464 N1149FLemery Aaron D · Chattaroy, WAS/N 17254744 N114AGRlc Aviation LLC · Ansted, WVBuilt 1979 · S/N U20604674 N114CZMinnesota Department Of Public Safety · Saint Paul, MNBuilt 1981 · S/N 18267892 N114FAJprg Aviation Inc · Orlando, FLBuilt 1978 · S/N 17271720 N114WPUniversal Aviators Academy Inc · El Monte, CABuilt 1976 · S/N 17267603 N11500Semmes James · El Centro, CABuilt 1975 · S/N 17702342 N11501Erickson Kirk E · Warroad, MNBuilt 1973 · S/N 15075466 N11506Fidk Inc · Warrenton, VABuilt 1975 · S/N 17702343 N11507Strickland Jed B · Bald Knob, ARBuilt 1973 · S/N 15075472 N1150LNida Kevin R · Santa Paula, CAS/N 15073274 N1150YHoffman Anthony J · Rathdrum, IDBuilt 1962 · S/N 15059550 N11510Falls Aero Inc · Great Falls, MTBuilt 1973 · S/N 15075473 N11513Erickson Tristan Scott · Port Townsend, WABuilt 1973 · S/N 15075475 N11514Kickstart Aviation LLC · Mayfield, KYBuilt 1974 · S/N 15075476 N11517Grier Robert M · Deland, FLS/N 15075479 N11519Kap Title Inc · Tucker, GABuilt 1973 · S/N 15075481 N1151BOrtiz Daniel · Edinburg, TXBuilt 1973 · S/N 15075478 N1151YCraigmyle William R · Cooperstown, NYBuilt 1962 · S/N 15059551 N11527Red Oak Commuter LLC · Red Oak, IABuilt 1973 · S/N 15075489 N11528Streeter Derek · Guilford, CTBuilt 1973 · S/N 15075490 N11529Registration Pending · Mattituck, NYRegistration pendingBuilt 1973 · S/N 15075491 N1152MRst Aviation LLC · Vero Beach, FLBuilt 1970 · S/N 17259452 N1152VGolden Eagle Consulting LLC · Williston, NDS/N R1722123 N11531Ireland Lois Trustee · Herndon, VAS/N 15075493 N11533Neal Robert J · Martinsville, INBuilt 1973 · S/N 15075495 N11534Litzau Melissa · Lake Lillian, MNS/N 15075496 N11538Fallon James R · Chestnut Hill, MABuilt 1973 · S/N 15075500

Back to AD 87-20-03 R2