Registered aircraft · 245

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:70-03-04-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:70-03-04-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:70-03-04-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:70-03-04-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:70-03-04-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:70-03-04-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.

N5825MLee Brian P · Kent, WABuilt 1969 · S/N 310P0125 N5843MEastern Aero LLC · Gibsonville, NCBuilt 1969 · S/N 310P0143 N5889MKinney James R · Vermillion, SDBuilt 1969 · S/N 310P0189 N590FMTrrek Enterprises LLC · Sunriver, ORBuilt 1966 · S/N 320D0095 N5916MQuest Aviation Inc · Lake City, FLBuilt 1973 · S/N 402B0365 N593DMLister John · Pipe Creek, TXS/N 402B1228 N600SMCapt Tony 185 LLC · Aurora, COBuilt 1966 · S/N 320E0084 N6151QNitro Zeus Inc · Wilmington, DEBuilt 1967 · S/N 320F-0001 N6156QGem State Transportation Inc · Hamilton, MTBuilt 1967 · S/N 320F-0006 N6184QMarc Inc · Bolton, MSBuilt 1968 · S/N 320F-0034 N6193QRedstar Air Shows Inc · Discovery Bay, CABuilt 1968 · S/N 320F-0043 N6195QSunny Aviation LLC · Kalispell, MTBuilt 1968 · S/N 320F-0045 N61RWAerial Services Inc · Cedar Falls, IABuilt 1966 · S/N 320E0001 N6249QKnudsen Russell G · East Troy, WIBuilt 1969 · S/N 401A0049 N624CAClarke Cecil Jr Trustee · Katy, TXBuilt 1975 · S/N 402B0876 N6255QValiair Limited Company Trustee · Casper, WYBuilt 1969 · S/N 401A0055 N6375XMiliano Air LLC · Lewes, DEBuilt 1978 · S/N 402B1338 N6384XPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1978 · S/N 402B1347 N6387XAir Exec Inc · Mount Pleasant, IABuilt 1978 · S/N 402B1350 N6396XAviation Tech Services LLC · Edgewater, FLBuilt 1978 · S/N 402B1355 N664RJGeneva Lakes Aviation LLC · Lake Geneva, WIBuilt 1975 · S/N 402B0854 N66DHKingsbury Raymond S · Farmington, MNS/N 320E0041 N676MFCoastal Resource Associates Inc · Christiansted, VIBuilt 1971 · S/N 402B0106 N67RKRiley Matthew · Xenia, OHS/N 310Q1107 N6838XOcean Flight Corp · Weston, FLBuilt 1978 · S/N 402B1346 N688SPSanchez Eddy B · Miami Gardens, FLS/N 402B0603 N68RDWilliams Gerald L · Malibu, CABuilt 1965 · S/N 320D0026 N69369Mobarak Motorsports LLC · Singer Island, FLBuilt 1973 · S/N 402B0516 N69571Michaels Daniel T · Mars, PABuilt 1973 · S/N 310Q0789 N695PGTurcaian Export Services Inc · ProvidencialsS/N 401A0114 N69983Ruble Air LLC · Mechanicsburg, PABuilt 1974 · S/N 310Q1055 N69PBAerocraft Papa Bravo LLC · Hallandale, FLS/N 402B-1248 N69RHWheels Down Air LLC · Toledo, OHS/N 401A-0122 N6RWMagee Creek Wings & Things LLC · Rice, WABuilt 1973 · S/N 310Q0751 N6SQTate Thomas E · Glendale, CABuilt 1972 · S/N 310Q0625 N701CJCenturion Aviation Ltd · Salina, KSBuilt 1968 · S/N 401A0022 N70SCMaine Mold & Machine Inc · Hartford, MES/N 401A-0032 N71MEB200 Holdings LLC · Gilbert, AZBuilt 1969 · S/N 401B0007 N72053South Aircraft Leasing Inc · Wilmington, DEBuilt 1974 · S/N 402B-0587 N720LRegistered aircraftBuilt 1968 · S/N 320F-0042 N728SCQuist David Andrew · Lake Jackson, TXS/N 310Q0989 N748MGEl Paso Aero Inc · El Paso, TXBuilt 1974 · S/N T310Q1128 N7508QZulu Hours LLC · Moneta, VABuilt 1969 · S/N 310Q0008 N7516QS Flight LLC · Evergreen, COBuilt 1972 · S/N 310Q0530 N7530QBas Part Sales LLC · Greeley, COBuilt 1970 · S/N 310Q0030 N7556QKent Schreiber Company · Greencastle, PABuilt 1972 · S/N 310Q0604 N755ACAirswiss Inc · Wilmington, DEBuilt 1968 · S/N 402A0001 N757CAKenyon Walter C · Eureka Springs, ARBuilt 1972 · S/N 310Q-0535 N7584QArnold Brandon M · Roswell, NMBuilt 1970 · S/N 310Q0084 N75GBPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1975 · S/N 402B0912

Back to AD 70-03-04 R1