Registered aircraft · 13,518

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:99-05-13-R1-WD') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD') 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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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:99-05-13-R1-WD')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
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.

N204PT A Infinities LLC · Dover, DEBuilt 1991 · S/N E-2601 N204PWFreeman Adam J · Long Beach, CABuilt 1976 · S/N M-1844 N2050LMolak Marc E · Austin, TXBuilt 1976 · S/N M-1859 N2050NPerks Andrew · Weatherford, TXBuilt 1978 · S/N E-1429 N2050YSomerville Elizabeth M · West Dennis, MABuilt 1978 · S/N CE-826 N2050ZPong William Robert · San Mateo, CABuilt 1978 · S/N D-10193 N2051BPlanepower LLC · Meridian, MSBuilt 1978 · S/N TC-2196 N2051KSocio Aviation Services LLC · Benton, KYBuilt 1978 · S/N D-10198 N2051LParker Joyce A · Topeka, KSBuilt 1976 · S/N MC-436 N2051WLeiwant Alan J · Montville, NJBuilt 1978 · S/N E-1410 N2051XArana Carlos · The Woodlands, TXBuilt 1978 · S/N E-1411 N2053LMaine Instrument Flight · Augusta, MEBuilt 1976 · S/N MB-812 N2053WOem Products Inc · Oklahoma City, OKBuilt 1965 · S/N D-7990 N2054LDillon Roby · Rockport, INBuilt 1976 · S/N M-1860 N2054NHampton Todd J · Plainfield, INBuilt 1978 · S/N D-10196 N2054WVerran Clinton T · Rochester Hills, MIBuilt 1965 · S/N D-7991 N2055DRegistration Pending · Alvaton, KYRegistration pending, pending cancellationBuilt 1952 · S/N D-3398 N2055PPechacek Justin D · Snyder, TXBuilt 1979 · S/N TC-2235 N2055UR & D Aircraft LLC · Port Orange, FLBuilt 1978 · S/N D-10204 N2056DBickert Marshal A · Springfield, VABuilt 1953 · S/N D-3399 N2056LHodges Fred Lloyd Jr · Ellabell, GABuilt 1976 · S/N MC-435 N2056NN2056n LLC · Wilmington, DEBuilt 1978 · S/N TJ-156 N20572Shaw Brian · Meadville, PABuilt 1979 · S/N D-10247 N2057ADesruisseaux Kemens · Clarksville, TNBuilt 1978 · S/N E-1420 N2057LWilson Michael Joseph · Los Banos, CABuilt 1976 · S/N M-1861 N2058AFlying J Aviation LLC · Lynden, WABuilt 1979 · S/N TC-2201 N2058CScorpion Aviation LLC · Hemet, CABuilt 1978 · S/N TK-85 N2058KCollins Jimmy · Spring, TXBuilt 1979 · S/N TK-66 N2058WSweet Fred A · Loves Park, ILS/N D-8192 N2059ABuerge Scott · Nevada, MOBuilt 1978 · S/N D-10202 N2059LBig Bend Community College · Moses Lake, WABuilt 1976 · S/N MB-808 N2059WMorgan Jeffrey B · Edgewater, FLBuilt 1965 · S/N D-7993 N205PMHochstetler Allen D · Fairfield, CABuilt 1964 · S/N D-7599 N205SAConner Brian J · Davenport, CAS/N EA-273 N20602Bromschwig Kurt F Trustee · Montgomery, TXS/N TJ-173 N20603Burlington Air Center Inc · Burlington, WIBuilt 1978 · S/N D-10207 N2060DBanys Christopher D · San Luis Obispo, CABuilt 1953 · S/N D-3402 N2060WBreskman David G · King Of Prussia, PABuilt 1965 · S/N D-7994 N2061AMckinney James C · Whitefish, MTBuilt 1978 · S/N E-1425 N2061KMile High Air Inc · Canyon, TXBuilt 1978 · S/N TJ-161 N2061UGulf Coast Camp LLC · Lafayette, LABuilt 1979 · S/N TC-2202 N2062BWalker Marshall E · Lancaster, SCBuilt 1979 · S/N D-10205 N2062LJohnson Robert A · Crawfordville, FLBuilt 1976 · S/N M-1863 N2062WMichalka James R · Portage, MIBuilt 1965 · S/N D-7996 N2063CKhumbu Flying Club · Wilmington, DEBuilt 1979 · S/N CE-838 N2063DJolly Delbert B · Modesto, CAS/N D-3404 N2063LPeterson Eric T · Port Townsend, WABuilt 1976 · S/N MB-809 N2063XKimbrough Paul E Jr · Saint Cloud, FLS/N M781 N20649Echo Lima LLC · Newport, ARBuilt 1979 · S/N TC-2206 N2064COchoa Stanley · Woodland, CABuilt 1979 · S/N TC-2212

Back to AD 99-05-13 R1 WD