Skip to content

Registered aircraft · 1,267

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:88-21-07-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:88-21-07-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:88-21-07-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:88-21-07-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:88-21-07-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:88-21-07-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.

N3161PEga Aero Specialty Services LLC · Beaufort, SCBuilt 1957 · S/N 23-1093 N3165PNordstrand Steven D · Oak Harbor, WABuilt 1957 · S/N 23-1097 N317PZFairmont State University · Fairmont, WVBuilt 1980 · S/N 27-8054047 N3187PAir Over Ground LLC · Helena, MTS/N 23-1124 N318RHN72jp Inc · Annandale, VABuilt 1976 · S/N 27-7654184 N31DEBarber Deans Elliott III · Selma, ALBuilt 1961 · S/N 27-504 N31FACarlisle Robert · Pensacola, FLBuilt 1960 · S/N 27-215 N31PCFlight World Inc · San Juan, PRBuilt 1958 · S/N 23-1349 N31RCJoey Os LLC · Darlington, PAS/N 27-2818 N31TUKalm Air Inc · Junction, TXBuilt 1973 · S/N 27-7305011 N31TVCornea Kevin Troy · Palm City, FLBuilt 1979 · S/N 27-7954054 N320RBLogan David J · Saint Helens, ORBuilt 1963 · S/N 27-2389 N3211PJudie Bear Air LLC · Bend, ORBuilt 1957 · S/N 23-1152 N321ACB & H Aviation LLC · Marion, KYBuilt 1974 · S/N 27-7405334 N321CCMclaughlin Ralph B · Groveland, CAS/N 277304950 N321NCArizona Air Salvage · Phoenix, AZBuilt 1977 · S/N 27-7754101 N3227PTucker Patricia A · Hamilton, MTBuilt 1957 · S/N 23-1114 N3229PRiggs Charles A · Pembroke Pines, FLBuilt 1957 · S/N 23-1172 N322SMShivers James C II · Columbus, OHS/N 27-4417 N3234LTarrant County College · Fort Worth, TXBuilt 1967 · S/N 27-3626 N3241PBravo Partners LLC · Payson, AZBuilt 1957 · S/N 23-1186 N3248PAero Spectra Corp · Boulder, COS/N 23-1193 N324RTTorres Rafael · Levittown, PRBuilt 1966 · S/N 27-3210 N3252PGodbout Kevin P · South Hadley, MABuilt 1957 · S/N 23-1197 N325LBGlobal Aircraft Trust Inc Trustee · Cheyenne, WYS/N 27-7305149 N3268POn Glideslope LLC · Middletown, DEBuilt 1957 · S/N 23-1213 N3276PFly Rite Aviation LLC · Fort Myers, FLS/N 23-1221 N3278YMiddle Tennessee State University · Murfreesboro, TNS/N 27-3714 N3279PSouth Bay Flight Training Center · Carolina, PRBuilt 1957 · S/N 23-1224 N3280PRiggin Flight Service Inc · Madison, SDBuilt 1956 · S/N 23-679 N3285PLsop Rentals Premier Asset Management LLC · Gowanda, NYBuilt 1957 · S/N 23-1233 N3292PCrosswindz Ranch LLC · Seminole, TXS/N 23-1242 N3298PCross Albert B III · Salinas, CABuilt 1957 · S/N 23-1248 N329SDAce Flight Center Inc · St Thomas, VIBuilt 1966 · S/N 27-3512 N32DMHulme Thomas L · Fountain Hills, AZBuilt 1959 · S/N 23-1692 N32JDDuflo Spray Chemical Inc · Bremen, NYS/N 27-372 N32RWSkylens LLC · Hammond, LABuilt 1971 · S/N 27-4667 N3301PDramstad Flying Service LLC · Helena, MTBuilt 1958 · S/N 23-1251 N3304PBucket List Aviation LLC · San Jose, CABuilt 1958 · S/N 23-1254 N3305PAir Royal · Middletown, DEBuilt 1958 · S/N 23-1255 N3307PAlbano James R · Oakham, MABuilt 1958 · S/N 23-1257 N3316PCrew Sourcing Inc · Wilmington, DEBuilt 1958 · S/N 23-1267 N3326PDean Marshall H · El Paso, TXBuilt 1958 · S/N 23-1277 N3329PStradley Anna M Trustee · Bozeman, MTBuilt 1958 · S/N 23-1280 N3339PGeorge James Cooper · Lenoir, NCBuilt 1958 · S/N 23-1291 N333FSAerodrome LLC · Louisville, KYBuilt 1969 · S/N 27-4456 N333JDDouglas Aero Inc · Fort Lauderdale, FLBuilt 1980 · S/N 27-8054016 N333PBBourne Hoppe & Associates LLC · Midland, MIBuilt 1975 · S/N 27-7654013 N333VAXrrx Inc · Wilmington, DEBuilt 1978 · S/N 27-7854099 N3341PDahl Troy M · Cedar Rapids, IABuilt 1958 · S/N 23-1294

Back to AD 88-21-07 R1