Skip to content

Registered aircraft · 26,232

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.

N601FNMachin James T · Chewelah, WABuilt 2019 · S/N 001 N601GHButzer Jeffrey D Trustee · Warrens, WIBuilt 2007 · S/N 601-028S N601HGRegistered aircraftBuilt 2007 · S/N 601-041S N601JHRoberson Brian J · Cullman, ALS/N 601-033S N601JRJumbo Gabrielle Inc · Wilmington, DEBuilt 1969 · S/N 15071513 N601NCSoutheast Lsa LLC · Jacksonville, FLS/N 6-9581 N601NMBarlow Steven J · Mansfield, OHBuilt 2006 · S/N 601-006S N601VBLowe William · Holmen, WIBuilt 2006 · S/N 601-017S N601WDDewane Ryan · Manitowoc, WIBuilt 2008 · S/N 601-061S N601WMPerkins Robert A · New Richmond, WIS/N 6-5531 N601WWVirginia 601 Flyers LLC · Vesuvius, VABuilt 2014 · S/N 6-6937 N601XPKrakowsky David H · Weirsdale, FLBuilt 2006 · S/N 601-021S N601ZYKratz Bradley L · Indiana, PABuilt 2008 · S/N 601057S N602Watkins Arlo S · Chandler, AZBuilt 1963 · S/N 15060073 N60203Mike Smith Aviation International Inc · Napa, CABuilt 1969 · S/N 15070142 N60205Garza Gilberto · Yuma, AZBuilt 1969 · S/N 15070144 N6020ADanielson Donald J · Walla Walla, WABuilt 1956 · S/N 28620 N6020GBuckley Michael J · Billings, MTBuilt 1969 · S/N 15071520 N6020RFly For Fun Aircraft LLC · Rockville, MDBuilt 1965 · S/N 17253689 N6020VWiethoff Kent · Fairfax, MNBuilt 1946 · S/N 7AC-1125 N6020YRainier Flight Service LLC · Renton, WABuilt 2011 · S/N 16200168 N60215Yoder Johnathan · Thompson Falls, MTBuilt 1969 · S/N 15070149 N60217Grensky Stephen R · Spokane, WABuilt 1969 · S/N 15070150 N6021RBechtold Richard · Broadlands, VABuilt 1966 · S/N 17253690 N60224Arc Aviation LLC · Frisco, TXBuilt 1969 · S/N 15070153 N60225Falcon Flight LLC · Las Vegas, NVBuilt 2011 · S/N 16200143 N60226Weston Jesse S · Spokane, WABuilt 1969 · S/N 15070155 N60227Ryan James E · Calvin, WVBuilt 1969 · S/N 15070156 N60228Greene James W · Brunswick, GAS/N 15070157 N6022HTroiano William G · Culpeper, VABuilt 1946 · S/N 19163 N6022RCunningham Gene Jr · Bristol, VABuilt 1965 · S/N 17253691 N6022THenderson Beverly A · Sharon Springs, KSBuilt 1964 · S/N 15060722 N60233C-150j LLC · Manchester, MIBuilt 1969 · S/N 15070161 N6023JR&M Steel Co · Caldwell, IDBuilt 1972 · S/N A1500323 N60249Bas Part Sales LLC · Greeley, COBuilt 1969 · S/N 15070170 N6024HWright Cecil A · Sanford, FLBuilt 1946 · S/N 19166 N6024JHangar 5 LLC · Wilmington, DEBuilt 1972 · S/N A1500324 N60254Holladay Aviation LLC · Jacksonville, FLBuilt 1969 · S/N 15070175 N60257Ouzounov Kaloian G · North Miami, FLBuilt 1969 · S/N 15070177 N6025ACullen Aviation LLC · Lafayette, LABuilt 1956 · S/N 28625 N6025GBenitez Marlin A · Potomac, MDBuilt 1969 · S/N 15071525 N6025JFasking Daniel M · Stanford, ILBuilt 1972 · S/N A1500325 N60266Registered aircraftBuilt 1969 · S/N 15070183 N60267Butterfield Rory Arden · Milan, NMBuilt 1969 · S/N 15070184 N60269Daufuskie Aerospace LLC · Daufuskie Island, SCBuilt 1969 · S/N 15070185 N6026JN6026j LLC · Opa Locka, FLBuilt 2011 · S/N 16200145 N60273Selover Terry D · Madison, WIBuilt 1969 · S/N 15070188 N6027AFlight World Inc · San Juan, PRBuilt 2011 · S/N 16200146 N6027JPark William G · Canby, ORS/N A1500327 N6027LRaskin Jack · Monroe, NJBuilt 2011 · S/N 16200147

Back to AD 94-05-05 R1