Skip to content

Registered aircraft · 68,369

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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.

N2616ARegistration Pending · Aleknagik, AKRegistration pendingBuilt 1952 · S/N 22-895 N2616WDenney David W · Fowler, COBuilt 1965 · S/N 962 N26170Figure I Foundation · Los Angeles, CABuilt 1940 · S/N 4102 N26172Flying Tigers Flight School Ltd · Houston, TXBuilt 1977 · S/N AA5A0465 N26179Richardson James D II · Bend, ORBuilt 1977 · S/N AA5A0468 N2617QKerhulas Anthony B · Santa Maria, CABuilt 1969 · S/N 17258707 N2617ZCroy Branden J · Kendallville, INBuilt 2001 · S/N 1301 N2618ALevin Henry · Medford, ORS/N 22-902 N2618PHenningson Terry · Centennial, COBuilt 1955 · S/N 22-2954 N2619DInman Steve · Billings, MTBuilt 1952 · S/N 20771 N2619PColdsmith Steven L · Chambersburg, PABuilt 1955 · S/N 22-2955 N2619WSmith Cecil · Fort Pierce, FLS/N 963 N261AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843789 N261BWinnie Mae Inc · Tallahassee, FLBuilt 1957 · S/N DH-134 N261BWPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020253 N261CCCook Christopher · Columbus, GABuilt 2019 · S/N 82373 N261DMOelmann Dennis J · Waverly, IAS/N 379 N261EZZokpodo Emmanuel K · Sacramento, CABuilt 1975 · S/N 28R-7635087 N261FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020259 N261FCVu Ai · Aiea, HIBuilt 1968 · S/N 28-24697 N261GTThompson Glen Maurice Jr · Wellington, FLBuilt 1999 · S/N V97050060 N261HHoward Clifford E · Auburn, WABuilt 1968 · S/N R.E.C.2 N261MOld Style Aircraft LLC · Ellsinore, MOS/N A-159 N261MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881311 N261PDYellow Bird Aviation LLC · Phoenix, AZBuilt 1942 · S/N 75-5669 N261RMOlandese Donald J · Newalla, OKBuilt 2011 · S/N 91507 N261VFBickley Clarence R · Jefferson, GABuilt 1989 · S/N 576R N261XEvans Dennis · Naples, FLBuilt 2000 · S/N 60239 N26200Ulmer Clarence G · Aladdin, WYBuilt 1940 · S/N 7501 N26206Breakey Phillip · Pickerington, OHBuilt 1977 · S/N AA5A0471 N2620CWhalen Shenandoah · Amelia, OHBuilt 1987 · S/N 0725 N2620MBooth Chance · Wasilla, AKBuilt 1946 · S/N 12-1091 N2621AFox Jeff R · Soldotna, AKBuilt 1952 · S/N 18-2168 N2621KBasmajian Zachary Robert · Peoria, AZBuilt 1954 · S/N 54-2629 N2621MWestern Oklahoma Aviation LLC · Clinton, OKBuilt 1977 · S/N 28-7816297 N2621QBrown Russell C · Howey, FLBuilt 1977 · S/N 28-7725202 N2621ZWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1998 · S/N 17280559 N26225Kilday Klayton D DBA · Dexter, ORBuilt 1989 · S/N 1138 N2622HBurgess John H · Tower, MNS/N 001 N2622MN2622m LLC · Rehoboth Beach, DEBuilt 1982 · S/N 0735M N2622TStenvers Aaron · Valley, NEBuilt 1991 · S/N 1823 N2622WMohamed Eman Z · Lubbock, TXBuilt 1966 · S/N 3295 N26234Compositec Inc · Manitowoc, WIS/N AA5A0458 N26236Mcdonnel Jack Edward Jr · Woodsboro, TXBuilt 1977 · S/N AA5A0475 N26237Registration Pending · Spokane, WARegistration pendingBuilt 1977 · S/N AA5A0476 N26239Rice Grantland S · Boston, MABuilt 1977 · S/N AA5A0477 N2623BWalton Indy R · Soldotna, AKS/N 5160 N2623PJd Aero LLC · Chester, SDBuilt 1955 · S/N 22-2959 N26240Gilmer Thomas · Deridder, LABuilt 1977 · S/N AA5A0478 N26244Clear Blue Aviation LLC · Melbourne, FLBuilt 1977 · S/N AA5A0480

Back to AD 90-04-06 R1