Registered aircraft · 75

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:2000-23-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:2000-23-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:2000-23-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:2000-23-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:2000-23-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:2000-23-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.

N60BTReklaw Management Co · Houston, TXBuilt 1987 · S/N 432 N64FSJetvue Texas LLC · Richardson, TXBuilt 1984 · S/N 417 N66VAFranco Plastering Inc · Naples, FLBuilt 1983 · S/N 375 N696RQAzul Aviation Inc · Burleson, TXS/N 311 N70DTJet Set Aviation LLC · Memphis, TNS/N 334 N711KEN711ke LLC · Wilmington, DEBuilt 1980 · S/N 288 N728TGDigital Interstate Management Inc · Keller, TXBuilt 1984 · S/N 420 N772DCBest Aircraft Deals LLC · Salt Lake City, UTS/N 410 N777HDButler Brian S · Oklahoma City, OKBuilt 1983 · S/N 397 N790JRTransenergie Inc · Houston, TXBuilt 1984 · S/N 424 N795FMCypress Aircraft Sales LLC · Clermont, FLS/N 228 N804CCPappas John · Cave Junction, ORBuilt 1980 · S/N 305 N807BFSale Reported · Bishop, CASale reportedBuilt 1976 · S/N 194 N816LCMarklyn Jet Parts LLC · Dallas, TXBuilt 1980 · S/N 291 N845TXButler Brian S · Oklahoma City, OKBuilt 1981 · S/N 342 N85PTWestwind Air LLC · Oklahoma City, OKBuilt 1980 · S/N 285 N890BA818 Operations Inc · Wilmington, DES/N 301 N894TWD Jm Holdings LLC · Sugar Land, TXBuilt 1981 · S/N 354 N900DMMwm Air LLC · Adrian, MIBuilt 1981 · S/N 358 N911GUTeam Aero LLC · Olathe, KSBuilt 1981 · S/N 343 N928HRHoward Aviation LLC · San Antonio, TXBuilt 1984 · S/N 415 N959JJJesus Saves LLC · Conroe, TXBuilt 1981 · S/N 319 N98BMVs Maritime LLC · Oklahoma City, OKBuilt 1976 · S/N 193 N98HGN98hg LLC · Sheridan, WYBuilt 1983 · S/N 394 N9RDFlying Colors Airparts Inc · Leesburg, FLS/N 220

Back to AD 2000-23-13