Registered aircraft · 3,961

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.

N35VCGomez Victor · Isabela, PRBuilt 1969 · S/N 401A0126 N361GCFff Leasing LLC · Dover, DES/N 414-0616 N3636CSale Reported · Galena, KSSale reportedBuilt 1966 · S/N 310K0137 N363RMMash Kity J LLC · Grand Rapids, MIBuilt 1974 · S/N 310R0046 N3640GTailwind Flight Center - Sue LLC · Sturgeon Bay, WIBuilt 1977 · S/N 310R0880 N364NYMarc Inc · Bolton, MSS/N 310R-0718 N365FDci Air LLC · Dodge City, KSBuilt 1980 · S/N 421C0854 N365RESouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 340A0459 N366DHummer Family Capital Aviation LLC · Boonton, NJBuilt 1966 · S/N 310K0230 N366MN366m LLC · Dover, DES/N 414A0026 N366MCHastings Steve T · Corpus Christi, TXS/N 414A1005 N367ATL&R Aircrafts Corp · Boynton Beach, FLBuilt 1972 · S/N 310Q0522 N36846Armbruster LLC · Amherst, OHBuilt 1979 · S/N 310R1600 N36862Linville Keith · Bend, ORBuilt 1979 · S/N 310R1605 N36885Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 340A0681 N36887Aa Aircraft Adventure LLC · Joplin, MOBuilt 1982 · S/N 414A0835 N36908Williams D Eric · Palm Springs, FLBuilt 1980 · S/N 402C0313 N36911Hyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0314 N36961Alpha 414a LLC · New Smyrna Beach, FLBuilt 1980 · S/N 414A0494 N3696GTfa Holding Corp · Daytona Beach, FLS/N 310R0898 N369RKKrum Force 1 LLC · Wichita, KSBuilt 1976 · S/N 421C0072 N369RMRothschild Jonathan Trustee · Tucson, AZBuilt 1976 · S/N 421C0071 N36CGDay Edwin Daniel · Richland, WABuilt 1969 · S/N 310P0075 N36DGRegistered aircraftBuilt 1977 · S/N 340A0331 N36DLCroll Robert H III · Jacksonville, ORBuilt 1969 · S/N 310P0113 N36EWSalzer Dustin J · Weatherford, TXS/N 310Q0521 N36KWEastern Aviation Publishing Inc · Center Harbor, NHS/N 310R0296 N36NCrossman Kyle D · Monroe, MIBuilt 1980 · S/N 3350004 N3705GSouthern Illinois University DBA · Murphysboro, ILS/N 310R0900 N37127Richland Aviation Inc · Sidney, MTBuilt 1977 · S/N 404-0114 N37181Jrs Aviation LLC · Falls City, NEBuilt 1980 · S/N 414A0511 N371STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 340A0300 N371SBN333bc LLC · Franktown, COS/N 421C1072 N3720GPersonal Space Aviation LLC · Nokomis, FLBuilt 1977 · S/N 310R0955 N37237Hudson Bay Holdings LLC · Lebanon, TNBuilt 1977 · S/N 310R0968 N37242Sol Aerial Surveys LLC · Las Vegas, NVS/N 310R0969 N37256Patriot Air Inc · Belleville, ILBuilt 1977 · S/N 310R0977 N37268H & S Aircraft LLC · Lewes, DEBuilt 1977 · S/N 310R0983 N37285Java Air LLC · Visalia, CABuilt 1979 · S/N 340A0953 N372CCLemieux Kenneth G · Oneida, TNBuilt 1974 · S/N 310Q1071 N372FCHeartland Aviation Inc · Alliance, NEBuilt 1971 · S/N 310Q0215 N372JCompass Rose Services Inc · Powell Butte, ORBuilt 1966 · S/N 320D0114 N372NMShelter Michael R · Sandy Lake, PABuilt 1970 · S/N 310Q0115 N37302Elrod Jason A · Seattle, WABuilt 1977 · S/N 340A0334 N37306Frescomar USA LLC · Miami, FLS/N 340A0336 N37315Atlantic Coast Contractors Inc · Denver, NCBuilt 1977 · S/N 340A0341 N3731GMaxwell Truck & Equipment LLC · State College, PABuilt 1977 · S/N 310R0906 N37343Bearings & Belts LLC · Carlsbad, NMBuilt 1977 · S/N 340A0358 N37356Congregation Rosh Hagivah Inc · Waterbury, CTBuilt 1977 · S/N 340A0364 N37360Tkn Holdings LLC · Pima, AZBuilt 1978 · S/N 340A0402

Back to AD 87-21-02 R1