Skip to content

Registered aircraft · 56,578

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N2216URegistered aircraftBuilt 1974 · S/N U20602355 N2216XSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1965 · S/N 337-0116 N22170Taylor Warren D · Las Vegas, NVBuilt 1967 · S/N 15068114 N22172Soerens Thomas D · Saint Charles, ILBuilt 1967 · S/N 15068115 N22177Gedney Douglas Kevin · Grand Haven, MIBuilt 1976 · S/N 177-02323 N2217CSale Reported · Kerrville, TXSale reportedBuilt 1979 · S/N 18267230 N2217LInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 18281674 N2217RParke Mike D · Twin Falls, IDBuilt 1968 · S/N T210-0367 N2217TTango LLC · Anchorage, AKBuilt 1968 · S/N 185-1369 N22183Allworth Burton · Wapello, IAS/N 15068121 N2218CMart Gary A · Bend, ORS/N 30518 N2218YDoran Jeffrey T · Westerville, OHS/N 17700018 N22190Mulhall Kathy · Fishtail, MTBuilt 1967 · S/N 15068127 N22191Perry Oien · Deadwood, SDBuilt 1967 · S/N 15068128 N22192Pecinovsky Clair · Cresco, IABuilt 1967 · S/N 15068129 N22194Schmidt James P · Omaha, NEBuilt 1967 · S/N 15068130 N22196Showah Michael F · Scottsdale, AZBuilt 1967 · S/N 15068132 N22197Frallicciardi Vincent Jtrust · Madawaska, MEBuilt 1967 · S/N 15068133 N2219CCarder Kent E · Lakeville, MNBuilt 1953 · S/N 30519 N2219DRogers David R · Lake Jackson, TXBuilt 1952 · S/N 20371 N2219ESorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N 17271189 N2219JMcnamara Bradley W · Seattle, WABuilt 1966 · S/N 15065419 N2219TDls Holdings Inc · Arlington, TXBuilt 1968 · S/N 185-1371 N221AGryczewski John · Olive Branch, MSBuilt 1956 · S/N 28413 N221AARegistered aircraftBuilt 1977 · S/N 21062293 N221AKRegistration Pending · Oakwood, OHRegistration pendingBuilt 1966 · S/N 188-0184 N221BGroeneweg Art A · Laclede, IDBuilt 1957 · S/N 34298 N221BFXtratech Corp · Davie, FLBuilt 1963 · S/N 21058135 N221DMRush Aviation LLC · Melrose, NMBuilt 1971 · S/N 17260155 N221EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2021 · S/N 172S12621 N221FWallin Joshua M · Moreno Valley, CAS/N 15061493 N221JEElgee John O · Anchorage, AKBuilt 1973 · S/N U20601990 N221KLMather Don · Sandusky, OHBuilt 1973 · S/N 17261348 N221MEKarabin Gerald D · Vicksburg, MIBuilt 2000 · S/N 172S8481 N221MFWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267380 N221MLWamu Fly N Fish LLC · Portland, ORBuilt 1972 · S/N 18261525 N221NYFarukh Shroff · Pittston, PABuilt 1981 · S/N 17274978 N221SMMccain Stephen M · Columbia, MSBuilt 1976 · S/N 17267274 N221TJSafety In Motion Flight Center Inc · Puyallup, WABuilt 1978 · S/N 17271059 N22202Gifford Gregory L · Naples, FLBuilt 1972 · S/N 21059717 N22203Koenig William J · Benedict, MDBuilt 1967 · S/N 15068138 N22205Venaleck Joan · Concord Township, OHBuilt 1974 · S/N 17264058 N22208Lamb Ryan C · Munster, INBuilt 1967 · S/N 15068142 N2220SSb Meridian LLC · Heber, CABuilt 1976 · S/N 21061165 N2220YFarid Zia Physical Therapist A Professional Corp · El Centro, CABuilt 2005 · S/N 18281676 N2221Conley James Andrew · Merced, CABuilt 1960 · S/N 52538 N22210Registration Pending · New River, AZRegistration pendingBuilt 1967 · S/N 15068144 N2221CCts Aviation Inc · Galesburg, MIBuilt 1953 · S/N 30521 N2221DChestnut Ridge Construction Inc · New Alexandria, PAS/N 20373 N2221RPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1998 · S/N 17280681

Back to AD 79-10-14 R1