Registered aircraft · 10,879

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:74-08-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-01') 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:74-08-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-01')
  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:74-08-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-01')
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.

N1001MRocky Mountain Ventures Inc · Cheyenne, WYBuilt 1970 · S/N 17259401 N1002MSchuler Mark E · Columbia, ILBuilt 1970 · S/N 17259402 N1004MReid Brian · Boise, IDBuilt 1970 · S/N 17259404 N1007THollar Larry · Winston Salem, NCBuilt 1973 · S/N 18262411 N1008MHottenstein William R · Kingston, PABuilt 1970 · S/N 17259408 N100AJN8006j LLC · Shiloh, ILBuilt 1972 · S/N 421B0322 N100CGGreene Carol W · Mahwah, NJBuilt 1972 · S/N 17261191 N100ELLeading Edge Leasing LLC · Wilmington, DES/N 310Q-0688 N100FPFlying Particles Inc · Livermore, CABuilt 1974 · S/N 18262957 N100HJClipper Air Inc · Tomball, TXBuilt 1974 · S/N 340-0334 N100JHSonic Aviation LLC · Carrollton, MSBuilt 1971 · S/N 310Q0421 N100LLPremiere Brand Meats · Shasta Lake, CABuilt 1973 · S/N 414-0429 N100MSky Odyssey Aviation LLC · Gulf Breeze, FLBuilt 1975 · S/N 17265590 N100RKEllingson Leslie B · Harwood, NDBuilt 1974 · S/N 17263551 N100SLOlson Gordon N · Racine, WIBuilt 1971 · S/N 18260900 N100TGBengtson Todd · Tyler, TXBuilt 1974 · S/N 310Q1150 N1011NBlue Skies Aircraft LLC · Zephyrhills, FLBuilt 1970 · S/N 17259525 N10171Fod Flyers LLC · Fort Dodge, IABuilt 1975 · S/N 17702315 N10176Abm Flights LLC · Pawleys Island, SCBuilt 1969 · S/N 18260141 N101CWAtlanta Technical College · Atlanta, GABuilt 1972 · S/N 177RG0290 N101GHSan Diego Community College District · San Diego, CAS/N 18260875 N101JHHi-Per Aviation Inc · Arroyo Grande, CABuilt 1972 · S/N 21059759 N101KSWright Kenneth D · Benton, ARBuilt 1974 · S/N 17263095 N101LJGrenier Garret P · Anchorage, AKBuilt 1976 · S/N 17267273 N101RKBlake James R · Marion, LABuilt 1972 · S/N 17261166 N101USUsaeroflight LLC · Greenville, SCBuilt 1972 · S/N 17260922 N101UTRudd James M · Lake Jackson, TXBuilt 1971 · S/N 17259900 N101WPScc Associates Ltd · Wilmington, DEBuilt 1975 · S/N 18264220 N101WSKarnick Mark C · Mesa, AZBuilt 1971 · S/N 17260218 N1020MWinner Philip · Houston, TXBuilt 1975 · S/N 18264208 N1020VCraig Air Inc · Wasilla, AKBuilt 1974 · S/N U20602404 N10213Sparks Tom · Palestine, ILBuilt 1975 · S/N 17702317 N1022MHilton David L · Shreveport, LABuilt 1975 · S/N 18264209 N10242Alexander Holding Services Inc · Newark, DEBuilt 1972 · S/N 21059704 N1024MEdwards Chris R · Meadow Vista, CABuilt 1975 · S/N 18264210 N1025MSupina Robert P · Richmond, TXBuilt 1975 · S/N 18264211 N1026MStinar Gary F · Lakeville, MNBuilt 1970 · S/N 17259406 N1027MLoomis Aviation LLC · Gahanna, OHBuilt 1970 · S/N 17259407 N1028MWenz Michael D · Gillette, WYBuilt 1975 · S/N 18264212 N102PRRico Aviation Services Inc · Miami, FLBuilt 1976 · S/N 17266462 N102SJHelms Robert J · Alton, UTBuilt 1971 · S/N 17259570 N10305Blunt Samuel N · Summerville, SCBuilt 1975 · S/N 17702319 N1037TJohnson Shem E · Bonners Ferry, IDBuilt 1972 · S/N 18260859 N1037VPulse Jeremy D · Moore, MTBuilt 1968 · S/N 18051989 N10410Clark George A · Worcester, MABuilt 1975 · S/N 17702321 N1041MHubbard Bennett L · Piedmont, ALBuilt 1975 · S/N 18264214 N10420Kinney Powell Mcvay · Coppell, TXBuilt 1975 · S/N 17702324 N10446Schell Brothers II LLC · Rehoboth Beach, DEBuilt 1973 · S/N 172-62515 N104HSErdmann Hollis K · Santa Monica, CABuilt 1973 · S/N 182-61758 N104KJb Aircraft LLC · Anchorage, AKBuilt 1969 · S/N 20700122

Back to AD 74-08-01