Registered aircraft · 28

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:83-06-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-06-05-R1') 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:83-06-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-06-05-R1')
  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:83-06-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-06-05-R1')
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.

N229APBrown Jeffrey L · San Luis Obispo, CABuilt 1977 · S/N 296/24-08 N260FSGreat Lakes Bp LLC · Cranston, RIBuilt 1982 · S/N 71247001 N260GHoon David · Wolf Creek, MTBuilt 1982 · S/N 635 N260GBBaldassarri Giuseppe · Carrollton, GABuilt 1986 · S/N 725 N260JRs Hangar 14 LLC · El Segundo, CABuilt 1987 · S/N 736 N260MTCarlomagno Kent Gene · San Rafael, CABuilt 1972 · S/N 3-80 N260SFSkythrills! LLC · Fullerton, CABuilt 1979 · S/N 374/35/001 N266SFEastern Stearman Inc Trustee · Leesburg, VABuilt 1969 · S/N 2-29 N26FDAbnc Air LLC · Wellington, FLBuilt 1978 · S/N 413 N26XDGallarate Raymond D · Sonoma, CABuilt 1987 · S/N 40-016 N409FDSouth Seas Aviation Ltd · Wilmington, DEBuilt 1987 · S/N 726 N452AMHedges Aviation Inc · Ronkonkoma, NYBuilt 1983 · S/N 40-004 N517PSemonian Gary A · Jasper, GAS/N 106 N596MAVolker Richard C · Niagara Falls, NYBuilt 1984 · S/N 727 N61FDInternational Air Services Inc Trustee · Carson City, NVS/N 719 N62FDOpportunity Development Corp · Carson City, NVBuilt 1983 · S/N 720 N67FDDragon Leasing Corp · Naperville, ILBuilt 1984 · S/N 728 N68FDVargas Emmanuel N · Murrieta, CABuilt 1988 · S/N 306 N701RGSchoepflin Robert Dennis · Palouse, WAS/N 11-10 N71FDFly Seby LLC · East Hampton, NYBuilt 1988 · S/N 572 N730WHoelzen Robert D Trustee · Kent, WABuilt 1968 · S/N 109 N751MSkythrills! LLC · Fullerton, CABuilt 1988 · S/N 571 N7895Matukaitis William K · Millbury, MABuilt 1968 · S/N 123 N797MSWilliamson Marc R · Parkville, MOBuilt 1969 · S/N 2-28 N93225Dr Carlton N Walker Dds LLC · Roswell, NMS/N 104 N942TALost Squadron Inc · Wilmington, DEBuilt 1971 · S/N 11-11 N943TADe Peyster Francis V · Canby, ORBuilt 1970 · S/N 11-01 N945TADms Aviation Services LLC · Wildwood, MOS/N 11-04

Back to AD 83-06-05 R1