Registered aircraft · 177

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

N816DSAdcock Raymond D · Cabot, ARBuilt 1955 · S/N CH-300 N824GFDavis Aviation Inc · Brandon, MSBuilt 1957 · S/N EH43 N82SPMaiden Robert · Williamson, GABuilt 1958 · S/N DH-174 N833QShiloh Aviation LLC · Ramer, TNBuilt 1960 · S/N DH-290 N840STransnational Aviation LLC · Arlington, TXBuilt 1962 · S/N LF-38 N844NBemidji Aviation Services Inc · Bemidji, MNS/N LF-42 N850BCadieux Gregg M · Scotia, NYBuilt 1960 · S/N DH-303 N85MCFrasier Samuel R · Gainesville, FLS/N DH-79 N85TMErwin Matthew Lee · Georgetown, INBuilt 1957 · S/N EH-8 N872GMWilliams Tod C · Sheffield, MAS/N DH-112 N888BSFrasca Thomas W · Champaign, ILBuilt 1956 · S/N DH-14 N888EKExcalibur Knight One LLC · Miami, FLBuilt 1967 · S/N LC-263 N888JTNyerges James · Midland, TXBuilt 1966 · S/N LP-21 N911PYOrchtrans Inc Trustee · Wilmington, DEBuilt 1960 · S/N LF-21 N918SNorton Wesley R · Medford, ORBuilt 1960 · S/N DH-302 N925DJErvin Joshua C · New Plymouth, OHBuilt 1958 · S/N DH-195 N92HBDawe Jon · Collierville, TNBuilt 1957 · S/N EH-57 N9322YRice Christopher · Albuquerque, NMS/N DH-289 N93MSTwin Bo Safety LLC · Griffin, GABuilt 1956 · S/N DH-37 N9518YDegryse Aaron · Alamo, CABuilt 1962 · S/N DH-334 N9546QNasair Aviation Services LLC · West Long Branch, NJBuilt 1966 · S/N LC-231 N9616YBrady Justin · Bell Buckle, TNBuilt 1962 · S/N DH-337 N9663RCaruso Matteo · Hockessin, DEBuilt 1960 · S/N DH-245 N9664R5pm LLC · Reston, VABuilt 1960 · S/N DH-246 N977TTechnical Systems Management Corp · Siler City, NCBuilt 1960 · S/N DH-264 N978BBank Of Utah Trustee · Salt Lake City, UTBuilt 1961 · S/N DH-314 N98SCThompsen David A · Clifton, ILBuilt 1960 · S/N DH-276

Back to AD 79-01-02 R2