Skip to content

Registered aircraft · 3,960

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.

N310TAW Ne Holdings LLC · Harrisburg, NEBuilt 1971 · S/N 310Q0441 N310TCWalton Mark · Martinsburg, PABuilt 1979 · S/N 310R1603 N310TGHupper Clifford E · Pelham, NHBuilt 1966 · S/N 310K0035 N310TJRegent Trust Corp Trustee · Wichita, KSBuilt 1973 · S/N 310Q0819 N310TLRegistered aircraftBuilt 1976 · S/N 310R0673 N310TMMerritt Ricky T · Mesa, AZBuilt 1977 · S/N 310R1208 N310TPSouthern Arkansas University Tech · Camden, ARS/N 310J0046 N310TQRegistration Inc · Kalispell, MTS/N 310Q0818 N310TSPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1980 · S/N 310R1883 N310TTTriple J Flying Inc · Wilmington, DEBuilt 1973 · S/N 310Q0810 N310TWHowe Phillip T · Oro Valley, AZBuilt 1978 · S/N 310R1264 N310TYSol Aerial Surveys LLC · Las Vegas, NVBuilt 1980 · S/N 310R2117 N310UDGorge Winds Aviation Inc · Fairview, ORBuilt 1975 · S/N 310R0160 N310UKInternational Air Services Inc Trustee · Carson City, NVS/N 310R-0584 N310VGGtc Services LLC · Ocala, FLBuilt 1977 · S/N 310R-0990 N310VHVan Horn Jeffrey · Jonesboro, ARBuilt 1969 · S/N 310P0180 N310VRWg Aircraft Holding Corp · Daytona Beach, FLBuilt 1976 · S/N 310R0655 N310VVMsl Air Inc · Sugar Grove, ILS/N 310R1561 N310WDHernandez Jr Raymond Trustee · Burleson, TXBuilt 1969 · S/N 310Q0238 N310WGMunro Donald W · Commerce Township, MIBuilt 1972 · S/N 310Q0412 N310WHLexington Air Services LLC · Greenwood, MSBuilt 1975 · S/N 310R0074 N310WJAg N310wj LLC · South Salt Lake, UTBuilt 1976 · S/N 310R0721 N310WPPardue William E · Fort Worth, TXBuilt 1965 · S/N 310J0019 N310WSN310ws LLC · Athens, ALBuilt 1975 · S/N 310R0612 N310WVHill Rick A · Bridgeport, WVBuilt 1973 · S/N 310Q0976 N310XPFour Aces Montana LLC · Missoula, MTBuilt 1960 · S/N 39254 N310XRValiair Limited Co Trustee · Casper, WYBuilt 1976 · S/N 310R0626 N310ZFlyin' Dog Air LLC · Niceville, FLBuilt 1979 · S/N 310R1573 N3110LYellowfin Aero LLC · Seminole, TXS/N 310J0110 N3114LWaniczek Otto J · Lancaster, CABuilt 1965 · S/N 310J0114 N311BC311bc LLC · Channelview, TXBuilt 1976 · S/N 421C0132 N311BTBob Air LLC · Concord, MAS/N 414A0453 N311CASouthern Wings LLC · Shreveport, LABuilt 1977 · S/N 421C0252 N311GRPfeffer David D · Jacksonville, FLBuilt 1966 · S/N 310K0199 N311JHHuaco Aviation LLC · Waco, TXBuilt 1980 · S/N 421C0814 N311KMDream Flight Florida LLC · Wellington, FLBuilt 1979 · S/N 340A0757 N311RWWashburn Harrill Gene Jr · Rutherfordton, NCBuilt 1974 · S/N 310R00117 N311SKDoyle Thomas Michael · New City, NYBuilt 1976 · S/N 310R0687 N3122LE C G Aviation Inc · Orange, CABuilt 1965 · S/N 310J0122 N3125LOxley Lake Solutions LLC · Lawton, MIBuilt 1965 · S/N 310J0125 N3127LContainer Stop Inc · Paso Robles, CABuilt 1965 · S/N 310J0127 N3127TSouth Valley Internet Inc · San Martin, CAS/N 340A-0025 N312CSFlybuys3 LLC · Lewes, DEBuilt 1977 · S/N 310R0959 N312MXRapid Imaging Solutions LLC · American Fork, UTBuilt 1965 · S/N 310J0033 N3131KAmazon Aero Corp · Wilmington, DEBuilt 1972 · S/N 402B0248 N3134LTrax Eric E · Vero Beach, FLBuilt 1965 · S/N 310J0134 N3135LTempelhof Aviation · Las Vegas, NVBuilt 1965 · S/N 310J0135 N313JHJam Three LLC · St George, UTBuilt 1974 · S/N 310Q1011 N313RWSarp Rentals LLC · Loudon, TNBuilt 1969 · S/N 414-0010 N314BBMarc Inc · Bolton, MSS/N 310R1836

Back to AD 87-21-02 R1