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.

N2084WBurkett James Austin III · New Port Richey, FLBuilt 1965 · S/N D-8009 N2085LFly More Drive Less LLC · Hot Springs, ARBuilt 1976 · S/N D-9908 N2088CBeech K Holdings LLC · Sheridan, WYBuilt 1959 · S/N D-6044 N2090LBarnes Seth M · Hot Springs, ARS/N D-10074 N2092WEarthcirc08 LLC · Chagrin Falls, OHBuilt 1966 · S/N D-8044 N2093WKliewer Silas M · Ulm, MTBuilt 1966 · S/N D-8039 N2097DDandekar Shree Ajit · Cedar Park, TXBuilt 1953 · S/N D-3442 N20ACOwen Ray L · Los Gatos, CABuilt 1972 · S/N D9371 N20GDCoffey James R · Evergreen, COBuilt 1957 · S/N D-5116 N20RLRose Timothy A · Hickory, MSBuilt 1972 · S/N D-9411 N2102DLong Kenneth C · Inverness, FLBuilt 1953 · S/N D-3447 N2105DCherwink David · Aledo, TXBuilt 1953 · S/N D-3450 N2105LBishop William E · Fredericksburg, TXBuilt 1976 · S/N D-9912 N2106DNewton Harold D Jr · Albuquerque, NMBuilt 1953 · S/N D-3451 N2108DN2108d LLC · Sheridan, WYBuilt 1953 · S/N D-3453 N210RMace Steven B · Ocala, FLBuilt 1967 · S/N D-8463 N2110Firczak Scott William · Mt Ulla, NCBuilt 1959 · S/N D-5901 N2111DKing Kaleb R · Wasilla, AKS/N D-3456 N2113LGilbert Ben · Omaha, NEBuilt 1976 · S/N D-9917 N2116LHagg Theodoor · Johnson City, TNBuilt 1976 · S/N D-9916 N2117DZudeck Austin · Toluca Lake, CABuilt 1953 · S/N D-3462 N2117LCottage Grove LLC · Oklahoma City, OKS/N D-9918 N211EEV35a Speedsters LLC · Henderson, COBuilt 1968 · S/N D-8888 N211QAIsland Time LLC · Rock Hill, SCBuilt 1953 · S/N D-3564 N2120DGray Charles E · Carbon, INBuilt 1953 · S/N D-3465 N2121DSale Reported · Ashland, OHSale reported, canceledBuilt 1953 · S/N D-3466 N2123DCraigmile David N · Monroe, CTBuilt 1953 · S/N D-3468 N2124LMax D Watkins Pc · Tulsa, OKS/N D-9920 N2126DValentino Franco · Hendersonville, TNBuilt 1953 · S/N D-3471 N2126LLuurtsema Jon A · Alto, MIBuilt 1976 · S/N D-9913 N2128DAlamo Adrian · Irvine, CABuilt 1953 · S/N D-3473 N212RJBishop Mike · Rifle, COBuilt 1964 · S/N D-7467 N212VGuilfoyle Robert J · Fairhope, ALBuilt 1976 · S/N D-9851 N2131DWiley David A · Arlington, TXBuilt 1957 · S/N D-3476 N2132LCsrh Ventures LLC · Lubbock, TXBuilt 1976 · S/N D-9923 N2135WLeary Kevin · Midland, TXBuilt 1974 · S/N D-9648 N2136DLeake Richard · Fresno, CABuilt 1953 · S/N D-3481 N2138DMigliaccio Jason · Palm Bay, FLBuilt 1953 · S/N D-3483 N21398Peterson Peter M · Silverado, CABuilt 1977 · S/N D-10077 N2139DJenkins James G · Stoneville, NCBuilt 1953 · S/N D-3484 N213MEMcgough Craig N · Ferris, TXBuilt 1958 · S/N D-5686 N213PBKofman Peter M · Mountain Grove, MOBuilt 1959 · S/N D-5791 N213QHardcopf Robert W · Apple Valley, MNBuilt 1965 · S/N D-7929 N2142DGlenn Kyle K · Ellendale, NDS/N D-3546 N2146DDerrer Anthony Robert · Livermore, CABuilt 1953 · S/N D-3491 N214DRMarsh David · Flower Mound, TXBuilt 1969 · S/N D-8997 N214MCCampbell Christian · Senoia, GAS/N D-6772 N214QHassenger Management Strategies Inc · San Antonio, TXBuilt 1965 · S/N D-7932 N214RCWhitcomb David · Morrisville, VTS/N D-7453 N2150DRegistered aircraftBuilt 1953 · S/N D-3500

Back to AD 94-20-04 R2