Registered aircraft · 23

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-03-06') 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-03-06') 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-03-06')
    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-03-06')
  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-03-06')
  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-03-06')
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.

N13YSAir 1st Aviation Companies Inc · Aiken, SCBuilt 1976 · S/N 694 N143JACosco & Associates Inc · Crestview, FLBuilt 1974 · S/N 324 N15TCStax Holdings LLC · Hot Springs, ARBuilt 1976 · S/N 692 N165MARegistered aircraftBuilt 1975 · S/N 326 N216CDLandry Camile J · Baton Rouge, LABuilt 1974 · S/N 323 N261WBNorthern Jet Sales LLC · Port Saint Lucie, FLBuilt 1975 · S/N 330 N305DSAircraft Operations LLC · Portland, ORBuilt 1975 · S/N 328 N316ENFayetteville Aviation Inc · Fayetteville, TNBuilt 1976 · S/N 349SA N325MASouthern Aviation LLC · Durham, NCBuilt 1974 · S/N 325 N375ACCelco Constantine Eng Lab Co · Wilmington, DEBuilt 1975 · S/N 327 N383TXPositive Rate LLC · Eatonton, GABuilt 1975 · S/N 332 N40KCAir 1st Aviation Companies Inc · Glendale, AZBuilt 1974 · S/N 322 N450FSRaju Leasing Co LLC · Jackson, MSBuilt 1976 · S/N 338 N486AFAir 1st Inc · Tyndall Afb, FLBuilt 1975 · S/N 329 N487AFAir 1st Aviation Companies Inc · Tyndall Afb, FLBuilt 1975 · S/N 333 N500PJFly2mellc · Ooltewah, TNBuilt 1974 · S/N 668 N54PCAxel Neil Jeffery · Portland, ORBuilt 1974 · S/N 319 N59KSOconnell Meares Investments Ltd · Tampa, FLBuilt 1974 · S/N 664 N687HBSouthern Jets Inc · Naples, FLS/N 687 N741FNAir 1st Aviation Co Of Ok · Tulsa, OKBuilt 1975 · S/N 658 N800EDClassic Aircraft Sales LLC · Wilmington, DES/N 339 N866DAir 1st Aviation Companies Inc · Aiken, SCBuilt 1974 · S/N 656 N892SCDrs Sandra M Krokos And Thomas P Kislan Pc · Drums, PABuilt 1979 · S/N 392 S.A.

Back to AD 75-03-06