Registered aircraft · 70

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-08-16') 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-08-16') 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-08-16')
    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-08-16')
  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-08-16')
  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-08-16')
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.

N735KSouth Seattle Community College · Seattle, WABuilt 1965 · S/N LJ-35 N758KCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1967 · S/N LJ316 N761KCentral Virginia Aviation Inc · Petersburg, VABuilt 1968 · S/N LJ-426 N76GMDodson International Parts Inc · Rantoul, KSS/N LJ-498 N812ACInternational Air Services Inc Trustee · Carson City, NVS/N LJ-123 N83TCDel Mar College · Corpus Christi, TXBuilt 1969 · S/N LJ-483 N899DCentral Virginia Aviation Inc · Petersburg, VABuilt 1968 · S/N LJ-386 N900BPColumbus State Community College · Columbus, OHBuilt 1965 · S/N LJ-61 N901WLBas Part Sales LLC · Greeley, COBuilt 1968 · S/N LJ-410 N90DNNational Aerotech Aviation Delaware Inc · Wilmington, DEBuilt 1969 · S/N LJ-437 N90FAFox Valley Technical College · Appleton, WIBuilt 1966 · S/N LJ-133 N90KALj369 LLC · Opa Locka, FLBuilt 1968 · S/N LJ-369 N90NCDodson International Parts Inc · Rantoul, KSBuilt 1968 · S/N LJ342 N90WLUniversity Of Maryland Eastern Shore · Princess Anne, MDBuilt 1969 · S/N LJ-461 N930KThree Zero Kilo LLC · Costa Mesa, CABuilt 1967 · S/N LJ-294 N944KCarmine Labriola Inc · Scarsdale, NYBuilt 1969 · S/N LJ-467 N96AGSouthern Star Aviation LLC · Missoula, MTBuilt 1967 · S/N LJ-260 N9838ZN B B S LLC · Kansas City, KSFirst renewal noticeBuilt 1969 · S/N LJ-435 N988SLInternational Services Management LLC · Heath, TXBuilt 1969 · S/N LJ-438 N9HWMullins Michael · Seaford, DEBuilt 1969 · S/N LJ-459

Back to AD 75-08-16