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.

N222SADenny Robert C · Fort Myers, FLS/N 15078576 N222SXPoore Robert A · Richfield, MNBuilt 2007 · S/N 222 N222TADeschene Michael R · Westminster, CABuilt 1968 · S/N 15069729 N222TXJ M Williams LLC · Stockton, CABuilt 1957 · S/N 29976 N222ZTBrickhouse Farm Field LLC · Lewes, DEBuilt 2020 · S/N BHLSA09-18/19 N22304Berry Dewey R · Lexington, SCBuilt 1968 · S/N 15068204 N22305Arend James E · Mesa, AZS/N 15068205 N22307Martin David O · West Mifflin, PABuilt 1968 · S/N 15068207 N2230898x LLC · Caddo Mills, TXBuilt 1968 · S/N 15068208 N2230JCragg Gordon E · Georgetown, TXS/N 15065430 N2230NHansen Aviation LLC · Savannah, GAS/N 12466 N2230VThompson Dan W · Canby, ORBuilt 1948 · S/N 14461 N22310Tackett Eric · Huntington, INBuilt 1968 · S/N 15068210 N22318Reggie Denis A Jr · Marietta, GABuilt 1968 · S/N 15068214 N2231DFisher Air LLC · Cardington, OHBuilt 1952 · S/N 20383 N2231HHorn Patricia A · Hartland, WIS/N 2854 N2231NStokes Michael J · Chino, CABuilt 1947 · S/N 12467 N22325Marlee B Thomas · Tolar, TXBuilt 1968 · S/N 15068216 N22329Guernsey G R · Belen, NMBuilt 1968 · S/N 15068219 N22335Johnson Marissa N · Avon, INBuilt 1968 · S/N 15068222 N2233DMerrill Christopher D · Albany Twp, MES/N 20385 N2233JPalmer Kim W · Lockport, NYBuilt 1966 · S/N 15065433 N2234Mcclure Nick · Midland, TXBuilt 2017 · S/N 001 N2234VWeed Kelli · Stevensville, MTBuilt 1948 · S/N 14465 N22351Air Discovery La LLC · North Hollywood, CABuilt 1968 · S/N 15068229 N22354Franks Cory · Idalou, TXS/N 15068232 N22355Quinones Steven · Forney, TXBuilt 1968 · S/N 15068233 N22359Diedrich Lawrence F · Edgemont, ARBuilt 1939 · S/N C-3619 N2235DHasner Mark A · Fairbanks, AKS/N 20387 N22360Levy Peter F · Augusta, KSBuilt 1968 · S/N 15068236 N22361Youngblood Steve R · Young Harris, GABuilt 1968 · S/N 15068237 N2236NWhitehouse Carol H · Vero Beach, FLBuilt 1947 · S/N 22874 N2236VHerrington Kevin M · Honey Grove, TXBuilt 1948 · S/N 14467 N2237JSudduth Mark E · Lancaster, PABuilt 1966 · S/N 15065437 N2237NLoucks Gregory B · Flushing, MIBuilt 1947 · S/N 12473 N2237VTodd Doug · Brainerd, MNS/N 14468 N22385Knutson Wayne R · Thompson, NDBuilt 1968 · S/N 15068248 N2238DFanoni Michael A · Colfax, CABuilt 1952 · S/N 20390 N2238JPearce William · Grants Pass, ORBuilt 1966 · S/N 15065438 N2238VPulte Frank A · Burton, MIS/N 14469 N223CCSmith Arnold J Trustee · Okarche, OKBuilt 2007 · S/N CC11-00038 N223PEMiller James L · Galena, ILBuilt 1946 · S/N 9336 N223REClausen John F · Dufur, ORBuilt 2007 · S/N CC11-00032 N223RGSale Reported · Conway, ARSale reportedBuilt 1946 · S/N 7AC-1464 N22401Knotek Larry A · Reno, NVS/N 15068256 N22409Tanner David A · Onalaska, TXBuilt 1968 · S/N 15068262 N2240JBreithaupt Tracy L · Alexandria, LAFirst renewal noticeBuilt 1966 · S/N 15065440 N22415Viking Wings LLC · Kindred, NDBuilt 1968 · S/N 15068266 N2242DField Barry C · Leverett, MABuilt 1952 · S/N 20394 N2242VNelson Richard · Edna, TXBuilt 1948 · S/N 14473

Back to AD 94-05-05 R1