Registered aircraft · 30

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

N1017Jednacz Scott T · Bixby, OKBuilt 1967 · S/N 41 N1143Bruder Niclas · Portland, ORBuilt 1966 · S/N 29 N11GVGrah David B · Bishop, CABuilt 1965 · S/N 6 N1263Browning John · Blairstown, NJBuilt 1968 · S/N 78 N1275Martin William F · San Antonio, TXBuilt 1968 · S/N 73 N130GLDziedzic Jan B · Plainfield, ILBuilt 1968 · S/N 69 N152FLevas Timothy J · Cardiff By The Sea, CABuilt 1966 · S/N 30 N174NEKoenig Colleen M · Edgewood, NMBuilt 1968 · S/N 76 N17BIndrebo James E · Healdsburg, CABuilt 1966 · S/N 21 N18LMartin J Campbell · Tehachapi, CABuilt 1966 · S/N 39 N245FForney James C · Spokane, WABuilt 1967 · S/N 49 N301BWBerry Wallace D Jr · Lafayette, ALBuilt 1965 · S/N 19 N301NRead Roderick F Jr · Grayslake, ILS/N 23 N301QMcgarraugh Barry L · Minden, NVBuilt 1967 · S/N 35 N301RGWebb James T · Plantersville, MSBuilt 1966 · S/N 31 N301RPSale Reported · Coupeville, WASale reportedBuilt 1967 · S/N 56 N306MKCarlson Michael L · Shelbyville, KYBuilt 1965 · S/N 14 N3304TBird Brian A · Hutchinson, KSBuilt 1965 · S/N 13 N4166ALaberge Lynda Lee M · Norman, OKBuilt 1967 · S/N 52 N4171Stewart William S · Buchanan, VABuilt 1967 · S/N 54 N4500Pierce David S · Ramona, CAS/N 70 N461RBBogardus George R · Jacksonville, ORS/N 10 N4749SOverton Wilbur Charles · Roanoke Rapids, NCBuilt 1966 · S/N 28 N5911Montague Mark W · Reno, NVBuilt 1967 · S/N 53 N615XItalo Valentino Vasili · Atlanta, GABuilt 1967 · S/N 40 N624XGifford Scott A · Mcminnville, ORBuilt 1965 · S/N 12 N7115Schipper Gail C · Longmont, COBuilt 1967 · S/N 50 N7161Allee Guy L Jr · Hillsboro, ORBuilt 1968 · S/N 67 N767MBradford John Kevin · West Linn, ORBuilt 1967 · S/N 55 N7879Thurber Charles H Jr · Mcalester, OKBuilt 1966 · S/N 24

Back to AD 68-07-02