Skip to content

Registered aircraft · 54,017

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.

N4330QSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 1971 · S/N 17260230 N4330UPalmer Dana G · Gatesville, TXS/N 15060330 N4331LOppegaard Craig E · Saint Louis Park, MNBuilt 1966 · S/N 17254400 N4331NThomsen Consulting Inc DBA · Monee, ILBuilt 1947 · S/N 7078 N4331QLewis Brandon · Columbiaville, MIBuilt 1971 · S/N 17260231 N4331RConsolidated Aviation Services LLC · Seymour, TNBuilt 1974 · S/N 17263084 N4332COdom Douglas · Jay, FLBuilt 1978 · S/N 18803135T N4332RHolland Peter B · Uniontown, WABuilt 1974 · S/N 17263085 N4332VKenaga Michael L · Downers Grove, ILBuilt 1948 · S/N 7238 N4333LDover Amanda · Littleton, NCBuilt 1966 · S/N 17254402 N4333RReigle Aviation · Palmyra, PABuilt 1974 · S/N 17263086 N4334LOcuto Vincent Louis II · Homestead, FLS/N 17269555 N4334NHardy John A · El Paso, TXBuilt 1947 · S/N 7075 N4334QDickey Alan J · Fort Wayne, INBuilt 1971 · S/N 17260234 N4334RAir Dakota Flite Inc · Hettinger, NDBuilt 1974 · S/N 17263087 N4334UTusko Air LLC · Choctaw, OKBuilt 1964 · S/N 15060334 N4335LClifford Gary G · Titusville, FLBuilt 1966 · S/N 17254404 N4335UHarrison Wesley V · Kemah, TXBuilt 1964 · S/N 15060335 N4335VMartin Edward I · Trinity Center, CABuilt 1948 · S/N 7241 N4336BAlthens Levi W · Wasilla, AKBuilt 1955 · S/N 26680 N4336LWiff Robert A · Tahuya, WABuilt 1966 · S/N 17254406 N4336MSouther Field Aviation Inc · Americus, GABuilt 1975 · S/N 18802472T N4336NKrcma William H · Washburn, WIBuilt 1947 · S/N 7073 N4337LWirt James · Goldsby, OKBuilt 1966 · S/N 17254408 N4337NAlldredge Aviation · Auburn, WABuilt 1947 · S/N 7072 N4337QHobart Aviation Inc · Akron, OHBuilt 1971 · S/N 17260237 N4337UStroope Jerry S · Pearland, TXBuilt 1964 · S/N 15060337 N4338LInsco Kay · Martin, TNBuilt 1966 · S/N 17254409 N4338QRegistration Pending · Salisbury, NCRegistration pendingBuilt 1971 · S/N 17260238 N4338RThompson Group Inc · Stockton, CABuilt 1974 · S/N 17263091 N4339BCurrie Andrew C · Oscoda, MIBuilt 1955 · S/N 26683 N4339QC & K Aero LLC · La Valle, WIBuilt 1971 · S/N 17260239 N4339RBurke Brian · Westlake, OHBuilt 1974 · S/N 17263092 N4339VColtrin Christopher S · Schaumburg, ILBuilt 1948 · S/N 7245 N433BPLeverock Richard C · Port Saint Lucie, FLBuilt 1981 · S/N P21000730 N433LLSkydive Coolidge Inc · Tempe, AZBuilt 1963 · S/N 18254737 N433PTPilot Training Center LLC · Miami, FLBuilt 1974 · S/N 17263088 N433RMRocky Mountain College · Billings, MTBuilt 1974 · S/N 17262914 N433SBRico Kermot Aviation LLC · San Clemente, CABuilt 1969 · S/N 18259876 N433WKingdom Air Corps · Sutton, AKBuilt 1953 · S/N 25962 N4340BMuehl John M · Maryland, NYBuilt 1955 · S/N 26684 N4340UBenford Kenneth R · Haleyville, ALS/N 15060340 N4341LCut And Snip Flyers LLC · South Weber, UTBuilt 1966 · S/N 17254412 N4341ROleary Paul V · Gold Creek, MTBuilt 1974 · S/N 17263094 N4342LChenaille Lawrence A · Martinsville, INBuilt 1966 · S/N 17254413 N4343LDiamond C Aviation LLC · Gentry, ARBuilt 1966 · S/N 17254414 N4343QK M Air Enterprises Inc · Corona, CABuilt 1971 · S/N 17260243 N4343REndless Sky Aviation Inc · Syracuse, NYBuilt 1974 · S/N 17263096 N4343UBurke Jonathan D · Gaylord, MIS/N 15060343 N4344BMckinnon Harvey T · Thompson Falls, MTBuilt 1955 · S/N 26688

Back to AD 87-20-03 R2