Registered aircraft · 4,787

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

N2138CAv Holding Co LLC · Polson, MTBuilt 1986 · S/N 46-8608020 N2138SStamm Roy Peter · Woodstock, GABuilt 1975 · S/N 21061099 N213JPEducators Aviation LLC · Wilmington, DEBuilt 1986 · S/N 4608030 N213MRogers Ronald J · Crystal Lake, ILBuilt 1978 · S/N 310R1335 N2143SBaiocchi Ken P · San Jose, CABuilt 1975 · S/N 21061104 N2145SHenry James · Bonita, CABuilt 1975 · S/N 21061106 N2149ZBauer Jeff C · North Falmouth, MABuilt 1980 · S/N 28-7916380 N214CCSteele Aviation LLC · Tuscaloosa, ALS/N 421C0670 N214DFGaylord Hangars LLC · Gaylord, MIBuilt 1973 · S/N 421B0461 N214MKoo C Carlos · Atherton, CABuilt 1985 · S/N P210-00863 N2153ROrton Sterling · Cedar City, UTS/N EA-540 N2158JMccormick Eugene C DBA · Tyler, ALBuilt 1979 · S/N T18803395T N215CBKw Bradley Associates LLC · Manlius, NYBuilt 1980 · S/N 340A1019 N215GNBbt Jewelry LLC · Miami, FLS/N P21000335 N216LBBail Air LLC · Port Saint Lucie, FLBuilt 1974 · S/N 414-0545 N216LHHackbarth Lee A · Bend, ORBuilt 1981 · S/N U20606057 N2181SGreer Kenneth R · Pittsburgh, PABuilt 1975 · S/N 21061142 N218CCSotally Tober LLC · Wilmington, DEBuilt 1979 · S/N 21063297 N218CFLevel 200 LLC · Charlottesville, VABuilt 1980 · S/N 340A0989 N21BCAmelse Troy · Chippewa Falls, WIBuilt 1980 · S/N EA-65 N21BESpecialized Helicopter Training LLC · Middleton, IDBuilt 1979 · S/N P21000456 N21CTFerreira Douglas B Trustee · Chico, CABuilt 1978 · S/N P21000021 N21GFBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 421B-0209 N21KDMrd Aviation LLC · Windsor, COBuilt 1979 · S/N 414A0439 N21KRNorcon Enterprises Inc · Amarillo, TXFirst renewal noticeBuilt 1979 · S/N P21000285 N21LTMission Flight · El Monte, CABuilt 1979 · S/N P21000216 N21NPRossi Michael · Ronan, MTBuilt 1978 · S/N TK-77 N21RGMacair Aviation LLC · Xenia, OHBuilt 1969 · S/N 20700066 N21SGTwo One Sierra Golf LLC · Seattle, WABuilt 1976 · S/N 421C0039 N21SSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 1978 · S/N 421C0473 N21WUDallas Aero & Sales LLC · Poplar, MTBuilt 1979 · S/N 421C0650 N2201UKorba Sean · San Jose, CABuilt 1997 · S/N EA-601 N220DPMyrick Richard Leon · Williamson, GABuilt 1966 · S/N 380 N220GDJoseph M De Lecce Trustee · Prather, CAS/N 414A0459 N220TJJaco Oil Co · Bakersfield, CAS/N 21063139 N220WBWells Propane Inc · Wells, NVBuilt 1974 · S/N 210-60194 N2211QHill Jeffrey A · Bridgeport, WVBuilt 1968 · S/N 421A0011 N22121Registration Pending · Georgetown, TXRegistration pendingBuilt 1972 · S/N 21059711 N2214Q421 Partners · Delphi, INBuilt 1968 · S/N 421A0014 N221PPLive Pilot Training LLC · Ankeny, IABuilt 1987 · S/N 46-08064 N221TBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 46-8508061 N2221QAviation Sales And Charter LLC · Dover, DEBuilt 1968 · S/N 421A0021 N22232Engeseth James Jr · Parker, COBuilt 1972 · S/N 21059730 N2226LSlyngstad Todd · San Jose, CABuilt 1999 · S/N EA-640 N2229SKey Lime Consultants LLC · Wilmington, DEBuilt 1976 · S/N 21061174 N222AXGraven Timothy G · Foristell, MOBuilt 1970 · S/N 414-0078 N222BJFlight Smith LLC · Orem, UTBuilt 1972 · S/N 414-0264 N222DKVestal Randy L · Darien, GABuilt 1982 · S/N 25-0721 N222FGSkytravel LLC · Victoria, TXBuilt 1981 · S/N 414A0823 N222GSLandau Management Services Inc · Topanga, CABuilt 1981 · S/N TJ384

Back to AD 75-09-13