Skip to content

Registered aircraft · 26,231

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-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N4666XHolmes Joseph E · Cherry Valley, CABuilt 1966 · S/N 15064716 N4667ESteffen James R · Washta, IABuilt 1950 · S/N 7EC-15 N4667LRebel Road Customs LLC · Yuma, AZBuilt 1966 · S/N 17254662 N4667MVeal Elijah C · Kenai, AKBuilt 1947 · S/N 11-176 N4669XLwl Aero LLC · Saint George, UTBuilt 1966 · S/N 15064719 N466SRKmt Alliance LLC · Kathleen, GABuilt 1967 · S/N 17255912 N4671CPleasant Valley Cattle Co Inc · Sturgis, SDBuilt 1953 · S/N 25615 N4671LCraft William J · New Baltimore, MIBuilt 1966 · S/N 17254666 N4672CHoover Rodney Allen · Wasilla, AKBuilt 1953 · S/N 25616 N4672EKajans Douglas L · Reno, NVBuilt 1950 · S/N 7EC-27 N4672XAmerican Piston Domestic LLC · Lonsdale, MNBuilt 1966 · S/N 15064722 N4673TEvans Douglas A · Amarillo, TXBuilt 1965 · S/N 594 N4673XRegistration Pending · Bloomingdale, OHRegistration pendingBuilt 1966 · S/N 15064723 N4674CN&C Enterprises LLC · Vine Grove, KYBuilt 1953 · S/N 25618 N4674XSaunders Christopher · Lehighton, PABuilt 1966 · S/N 15064724 N4675XBlalock Merrel K III · Mayflower, ARS/N 15064725 N46765Janachowski John C · Plainfield, ILBuilt 2007 · S/N 21 N4677CRegistered aircraftBuilt 1953 · S/N 25621 N4677EStults Christopher · Wray, COBuilt 1950 · S/N 7EC-25 N4677LJet Airways Express Inc · Aventura, FLBuilt 1966 · S/N 17254672 N4677MRussell Adam G · Easton, MEBuilt 1947 · S/N 11-186 N4677XBaird Harvey L · Sharon, OKFirst renewal noticeS/N 15064727 N46785Budde Air Racing Enterprises Inc · Oklahoma City, OKBuilt 1980 · S/N GDA-003 N4678ENorthwind Capital Holdings Inc · Anchorage, AKBuilt 1950 · S/N 7EC-26 N4678HStevens Cole J · Coeur D Alene, IDS/N 17-79 N4679CDahl Dan P · Wasilla, AKBuilt 1953 · S/N 25623 N4679E3218t Inc · Omaha, NEBuilt 1950 · S/N 7EC-28 N4679LFitting Solutions Lc · Chester, NJBuilt 1966 · S/N 17254674 N4679XVentura Joel · Andover, MABuilt 1966 · S/N 15064729 N4680EJohnson Keith M · Creswell, ORBuilt 1950 · S/N 7EC-29 N4680LWasilowski Steven P · Elgin, ILBuilt 1966 · S/N 17254675 N4681EStrahan Ronald R · Girard, KSBuilt 1950 · S/N 11CC-276 N4681LOmer Syeda · Gilroy, CAS/N 17254676 N46822Dilks Alexaner J · New Castle, DEBuilt 1977 · S/N 76-4 N4682LJones Carl R · Little Rock, ARBuilt 1966 · S/N 17254677 N4683ERegistration Pending · Delanson, NYRegistration pendingBuilt 1950 · S/N 7EC-31 N4683LLawson Seth A · Morgantown, WVBuilt 1966 · S/N 17254678 N4684LHowell Tyler L · Romoland, CABuilt 1966 · S/N 17254679 N4685HMann Thomas A · Ford, WABuilt 1946 · S/N 17-84 N4685LEsquilin Steven C · Poway, CABuilt 1966 · S/N 17254680 N4685XFite Robert G · Brookings, SDBuilt 1966 · S/N 15064735 N4687CBendixen Ralph R · Palmer, AKBuilt 1953 · S/N 25631 N4687EMaslen Holbrook · Caldwell, IDS/N 7CCM-217 N4687LKful Inc · Fullerton, CABuilt 1966 · S/N 17254682 N4688LFas Aircraft Aerowork Corp · Miami, FLBuilt 1966 · S/N 17254683 N4688MBrewer Samuel T · Wasilla, AKFirst renewal noticeBuilt 1947 · S/N 11-197 N4688XMather Paul L · Saint Elmo, ALBuilt 1966 · S/N 15064738 N46896Foley Sumner R · Spring Hill, FLBuilt 1942 · S/N 058B-2872 N4689EKelly Michael A · Anchorage, AKBuilt 1950 · S/N 7EC35 N4689MRoy Cybulski Farms Inc · Caro, MIBuilt 1947 · S/N 11198

Back to AD 94-05-05 R1