Registered aircraft · 650

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

N10480Piper 66 LLC · Kirksville, MOBuilt 1966 · S/N 32-279 N105DYYeager Daniel C · Iowa City, IABuilt 1966 · S/N 32-467 N1061QLbdd Enterprises 61q LLC · Pittsburgh, PABuilt 1977 · S/N 32-7200015 N106NAVann-Tage Point Aviation LLC · New Castle, DES/N 32-704 N111AJBergin Donald M · Ormond Beach, FLBuilt 1972 · S/N 32-7200041 N111FCWoody Air LLC · Vero Beach, FLBuilt 1968 · S/N 32-1030 N1161XBarnett Donald R · Atoka, TNBuilt 1975 · S/N 32-7500040 N116BKDacy Roy W · Rockport, TXS/N 32-782 N121SClark William H IV · Thurmont, MDBuilt 1966 · S/N 32-835 N123LUSutton Aircraft Salvage LLC · Palmer, AKS/N 32394 N123MFAronhalt Daniel E · Columbus, INBuilt 1968 · S/N 32-1069 N1246TRegistration Pending · Fort Mc Coy, FLRegistration pendingBuilt 1972 · S/N 32-7200034 N1297HHop A Chopper Inc · Dover, DES/N 32-7700010 N130GHBose Tamal · Tucson, AZBuilt 1965 · S/N 32-124 N140JGBarros Vincent · Kissimmee, FLBuilt 1974 · S/N 32-7400043 N1424MFly High LLC · Mobile, ALBuilt 1973 · S/N 32-7300043 N1426THillcrest Of Central Fl LLC · Auburndale, FLBuilt 1972 · S/N 32-7200038 N1450XHopkins David M · Bell Buckle, TNBuilt 1975 · S/N 32-7500042 N1465TCaudle Tommie A · Bentonville, ARBuilt 1972 · S/N 32-7200040 N146SCFantasy Aire Inc · Wilmington, DEBuilt 1968 · S/N 32-985 N1489TLion Aviation LLC · Kansas City, MOBuilt 1972 · S/N 32-7200042 N1497XTundra Toyo And Heating LLC · Nome, AKBuilt 1975 · S/N 32-7500038 N15126Registration Pending · Mc Caysville, GARegistration pendingBuilt 1972 · S/N 32-7300002 N15134Roe Robert D Jr · Naples, FLBuilt 1972 · S/N 32-7300003 N15383Nevill Donald L · Clare, MIBuilt 1972 · S/N 32-7300006 N15476Lengacher Caleb Lee · Montezuma, GABuilt 1972 · S/N 32-7300008 N15538Schwartz David · Lakeland, FLBuilt 1972 · S/N 32-7300009 N15551Buchanan Jennings R · Cocoa Beach, FLBuilt 1972 · S/N 32-7300010 N15646Smith Michael S · Norman, OKBuilt 1972 · S/N 32-7300012 N15788Chafin Gerald III · Mountain Home, ARS/N 32-7300016 N15939Ray H Gregg · Nashville, GABuilt 1973 · S/N 32-7300021 N15961Kings Wings · Jupiter, FLBuilt 1973 · S/N 32-7300022 N16332Brown Chritopher M · Lake Helen, FLBuilt 1973 · S/N 32-7300023 N16378Lapair Inc · Vero Beach, FLBuilt 1973 · S/N 32-7300026 N16396Nobrainer Holdings LLC · Fort Lauderdale, FLBuilt 1973 · S/N 32-7300027 N1643HSiegenthaler Dean · Mineral Point, WIBuilt 1977 · S/N 32-7700011 N164LLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 32-714 N164ULariviere Jeffrey A · Douglassville, PABuilt 1967 · S/N 32-996 N166NGVaught Timothy A · Mauldin, SCBuilt 1975 · S/N 32-7500016 N173SNWilliams Hoffman Alexander M · Downers Grove, ILBuilt 1967 · S/N 32-912 N176WBVincent David R · Hartley, TXBuilt 1976 · S/N 32-7600013 N17MDMoyer David · Katy, TXBuilt 1966 · S/N 32-552 N1804HBl&B LLC · Knoxville, TNBuilt 1977 · S/N 32-7700012 N18BRFly Ohio Inc · Columbus, OHBuilt 1966 · S/N 32-371 N1981HRegistration Pending · Saint Louis, MORegistration pendingBuilt 1977 · S/N 32-7700013 N198TLulfs Mark E · Mancelona, MIS/N 32-7200029 N1999SVernon Margo L · Friendship, TNBuilt 1969 · S/N 32-1162 N19HJLogan Lonnie L · Grand Island, NEBuilt 1973 · S/N 32-7300020 N200CF200cf LLC · Decatur, ILS/N 32-7700005 N207VRB&C Properties LLC · Bristol, WIS/N 32-58

Back to AD 67-03-07