Skip to content

Registered aircraft · 3,959

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-21-02-R1') 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-21-02-R1') 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-21-02-R1')
    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-21-02-R1')
  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-21-02-R1')
  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-21-02-R1')
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.

N1083QAhlhorn Travis W · San Marcos, TXBuilt 1963 · S/N 310H0083 N108LVVandermolen Louis A Md · Laguna Beach, CAS/N 414A0841 N109CBSasser Edward Craig · Albemarle, NCBuilt 1975 · S/N 340-0533 N10AAPeterson Andrew · Louisville, KYBuilt 1966 · S/N 320E0046 N10BDCalkins Mark E · Longview, TXBuilt 1978 · S/N 310R1539 N10ETTech Nav LLC · Columbus, INBuilt 1971 · S/N 310Q0415 N10FCKnott Me LLC · Phoenix, AZBuilt 1973 · S/N 310Q0796 N10FFValiair Lc Co Trustee · Casper, WYBuilt 1976 · S/N 421C0082 N10KMJohnson Walter N · Hico, TXS/N 310I0101 N10PRVillalobos Jesus F · Farmington, NMBuilt 1961 · S/N 310-0032 N10XEBlaikie Thomas B · Kenner, LABuilt 1973 · S/N 340-0221 N1103QHenderson Phillip Kimon III · Benton Harbor, MIBuilt 1963 · S/N 310H0103 N1105QSundale Aviation Inc · Erwinna, PABuilt 1963 · S/N 310H0105 N1106QOrellana Wilson · Hesperia, CAS/N 310H0106 N1107QValiair Limited Co Trustee · Casper, WYBuilt 1963 · S/N 310H0107 N110CSFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1972 · S/N 310Q0616 N110DHYingling Consultation LLC · Wilmington, DES/N 421B0137 N110VEHorizon Group Inc Trustee · Boca Raton, FLBuilt 1977 · S/N 414A-0017 N1112QLastowski Gerald J · Gulf Breeze, FLBuilt 1963 · S/N 310H0112 N111BXDonadio Robert F · Amherst, NHBuilt 1972 · S/N 414-0368 N111EAExecutive Air Inc · Roanoke, VAS/N 310R0245 N111GTMorgan Gerald W · Hillsboro, TXS/N 340-0188 N111NCDaxair Aviation LLC · Scottsdale, AZBuilt 1975 · S/N 310R0182 N111PJG&L Aviation Services LLC · Las Vegas, NVBuilt 1981 · S/N 340A1234 N111RBClear Skies LLC · Allentown, PABuilt 1978 · S/N 340A0545 N111SDMarc Inc · Bolton, MSBuilt 1969 · S/N 310P0200 N111TFPacific Aviation Aircraft Management Inc · Ontario, ORBuilt 1974 · S/N 421B0660 N111TLNdk Global Holdings Corp · Dover, DEBuilt 1974 · S/N 421B0645 N111XBoone Aviation Ltd · Denver, COBuilt 1965 · S/N 310J0108 N1121QTwomey Kieran S · Coronado, CABuilt 1963 · S/N 310H0121 N1129QTippecanoe Valley Aero Inc · Delphi, INBuilt 1963 · S/N 310H0129 N112ALPassport Auto & Aviation Inc · Richmond, VABuilt 1979 · S/N 421C0697 N112HPBertagnole Karl R · Wright, WYBuilt 1964 · S/N 310I0104 N112MJTm Aero LLC · Riverview, FLS/N 421C0907 N112WWAmerican Smooth Aviation LLC · Rock Hill, SCBuilt 1977 · S/N 310R1215 N1133QHaggard Haley G · Springer, OKBuilt 1963 · S/N 310H0133 N113GLBushwacker Aviation LLC · Benton, ARBuilt 1978 · S/N 414A0072 N113KKolstad Christopher Van · Galata, MTBuilt 1975 · S/N 310R0107 N113MPBan Air LLC · Boerne, TXBuilt 1982 · S/N 421C1235 N1141XChancellor Aviation LLC · Billings, MTBuilt 1978 · S/N 414A0215 N114AMLon Air LLC · Longwood, FLBuilt 1977 · S/N 310R0887 N114HVAerowerks LLC · Georgetown, TXBuilt 1973 · S/N 421B0371 N114MHVlavic Aviation LLC · Hallandale Beach, FLBuilt 1979 · S/N 414A0458 N115BHBighorn Airways Inc · Sheridan, WYBuilt 1982 · S/N 340A1531 N115EATso Aviation LLC · Conway, ARBuilt 1978 · S/N 340A0484 N116EALewistown Aviation Inc · Lewistown, PABuilt 1979 · S/N 340A0750 N116JJProgress Aviation LLC · Ellicott City, MDBuilt 1984 · S/N 421C1404 N116JWAcvtg Aviation LLC · Wilmington, DEBuilt 1980 · S/N 335-0030 N116PAJht Aircraft LLC · Wilmington, DEBuilt 1978 · S/N 414A0021 N117JDVintage Motors Inc · Beattyville, KYBuilt 1967 · S/N 310L-0167

Back to AD 87-21-02 R1