Registered aircraft · 29

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:2005-08-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:2005-08-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:2005-08-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:2005-08-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:2005-08-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:2005-08-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.

N10874Lake Elsinore Soaring Club · Wildomar, CABuilt 1972 · S/N 016 N208ASHardy Sandra N · Monson, MEBuilt 1977 · S/N 272 N21TUAero Club Albatross · Blairstown, NJBuilt 1974 · S/N 133 N278ASBock Bryce K · Longwood, FLS/N 251 N280DTToews Donald W · Waipahu, HIBuilt 1977 · S/N 280 N303TMNorth Florida Soaring Society Inc · Jacksonville, FLBuilt 1977 · S/N 273 N38JEPham Loc G · Westminster, CAS/N 176 N413PJLinda K Howe · Parma, OHBuilt 1974 · S/N 148 N484BOdonnell Daniel V · Dover, DEBuilt 1974 · S/N 208 N4BBBock Bryce K · Longwood, FLS/N 020 N581DBBaldassarri Giuseppe · Carrollton, GABuilt 1977 · S/N 262 N62516N304mg LLC · Homestead, FLBuilt 1973 · S/N 063 N64775Adams Bob L · Eagle River, AKBuilt 1977 · S/N 254 N65317Mahony John · Ballston Spa, NYBuilt 1976 · S/N 190 N65332Utah Soaring Association Inc · Mapleton, UTBuilt 1974 · S/N 164 N65394All Attitude Aviation Inc · Edgewater, FLBuilt 1976 · S/N 216 N69AZWelch Troy O · Graford, TXBuilt 1974 · S/N 205 N75ASCoffield Alan · Canyon Lake, CABuilt 1977 · S/N 274 N76PSFranconia Soaring Association Inc · Franconia, NHBuilt 1974 · S/N 146 N774PSDewitt Joseph W III · Yorktown, VABuilt 1976 · S/N 203 N7CKConner Walter Larry · Los Lunas, NMBuilt 1976 · S/N 187 N81YVMahony John · Ballston Spa, NYS/N 156 N855GHThiemar Martin · Mineral Ridge, OHBuilt 1974 · S/N 139 N89ASSwanson Thomas G · Seaford, VABuilt 1976 · S/N 248 N8DKFlying L Aircraft Inc · Fort Denaud, FLBuilt 1976 · S/N 236 N9136YHoyt Robert M · Rogers, ARS/N 060 N9222ZMitchell John J · Chevy Chase, MDBuilt 1974 · S/N 163 N93458Smith Stephen A · Erwinna, PABuilt 1973 · S/N 061 N99990Pickens Edward C · Raleigh, NCBuilt 1974 · S/N 158

Back to AD 2005-08-07