Skip to content

Registered aircraft · 4,469

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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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.

N2041WJimenez John D · San Antonio, TXS/N D-7982 N2042BHasemann James M · Gaithersburg, MDBuilt 1978 · S/N D-10185 N20478V35b Bonanza LLC · Temecula, CAS/N D-10194 N2047WKapusta Marian · Clearwater, FLBuilt 1965 · S/N D-7986 N2048WTripi Mark DBA · Parkersburg, WVBuilt 1965 · S/N D-7987 N2049NAdvanced Aviation LLC · New Century, KSBuilt 1978 · S/N D-10190 N2049WHufford P Thomas Trustee · San Diego, CABuilt 1965 · S/N D-7985 N204BTulin Bradley G · Sedona, AZBuilt 1956 · S/N D-4548 N2050ZPong William Robert · San Mateo, CABuilt 1978 · S/N D-10193 N2051KSocio Aviation Services LLC · Benton, KYBuilt 1978 · S/N D-10198 N2053WOem Products Inc · Oklahoma City, OKBuilt 1965 · S/N D-7990 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 N2055UR & D Aircraft LLC · Port Orange, FLBuilt 1978 · S/N D-10204 N2056DBickert Marshal A · Springfield, VABuilt 1953 · S/N D-3399 N20572Shaw Brian · Meadville, PABuilt 1979 · S/N D-10247 N2058WSweet Fred A · Loves Park, ILS/N D-8192 N2059ABuerge Scott · Nevada, MOBuilt 1978 · S/N D-10202 N2059WMorgan Jeffrey B · Edgewater, FLBuilt 1965 · S/N D-7993 N205PMHochstetler Allen D · Fairfield, CABuilt 1964 · S/N D-7599 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 N2062BWalker Marshall E · Lancaster, SCBuilt 1979 · S/N D-10205 N2062WMichalka James R · Portage, MIBuilt 1965 · S/N D-7996 N2063DJolly Delbert B · Modesto, CAS/N D-3404 N2064DLaing Malcolm B · Lubbock, TXS/N D-3405 N20654Spatz Phillip D · League City, TXBuilt 1979 · S/N D-10212 N2065YAbel Instruments Inc · Riviera Beach, FLBuilt 1979 · S/N D-10211 N2066DBair Jack Martin · Oklahoma City, OKBuilt 1953 · S/N D-3407 N2066NBobo Kenneth · Auburndale, FLBuilt 1979 · S/N D-10215 N2068DKelley Foy L · Oakdale, CAS/N D-3425 N2069DSchlegel Robert A · Windermere, FLS/N D-3426 N206BHand James K · Alton, ILBuilt 1953 · S/N D-3479 N2072WNewsome Jeff · Blackwell, OKBuilt 1965 · S/N D-8001 N2073DWitte Timothy P · Sharon Springs, NYBuilt 1953 · S/N D-3493 N2073WPlowden William E Jr · Shelby, NCBuilt 1965 · S/N D-8003 N2074GWinder Gary W Jr · Thornton, COS/N D-3617 N2075WCooper Jeffrey B · Eagle River, AKBuilt 1965 · S/N D-8005 N2076DChild Benjamin H · Rexburg, IDBuilt 1953 · S/N D-3428 N2077DKloster Ethan · Tarzana, CABuilt 1953 · S/N D-3429 N207DWest Coast Aircraft LLC · Carson City, NVBuilt 1957 · S/N D-3461 N2080DSoller Nicholas · Plainsboro, NJBuilt 1953 · S/N D-3431 N2080LSparks Halli · Burdett, NYBuilt 1976 · S/N D-9902 N2080SRobinson Earl J · Cotuit, MABuilt 1966 · S/N D-8357 N2081DSharon Enterprises LLC · Peralta, NMBuilt 1953 · S/N D-3492 N2081WN5724v LLC · Kalispell, MTBuilt 1965 · S/N D-8007 N2082WRegistered aircraftBuilt 1965 · S/N D-8008 N2083LHorizon Chaser LLC · Woodway, TXS/N D-9904

Back to AD 94-20-04 R2