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.

N401RSTraining Services Inc DBA · Virginia Beach, VABuilt 1967 · S/N 401-0073 N401WMMrd Aero LLC · Manheim, PABuilt 1972 · S/N 401B0219 N401WWAttitude Aviators Inc · North Myrtle Beach, SCBuilt 1968 · S/N 401-0275 N402AJ2lyons Enterprises LLC · Wellington, FLBuilt 1975 · S/N 402B0884 N402BFSnell Marion Lea · Ackerly, TXBuilt 1975 · S/N 402B1010 N402CENorth American Aerial Surveys LLC · Tucson, AZBuilt 1973 · S/N 402B0364 N402CZEmission-Air Inc · Welcome, NCBuilt 1972 · S/N 402B0213 N402DZSamadi Jamshid · Leesburg, VAS/N 4020214 N402NKKhan Pervez · Miami Springs, FLBuilt 1972 · S/N 402B0314 N402PAAir Flight Inc · Fort Lauderdale, FLBuilt 1973 · S/N 402B0329 N402SSKellair Ltd Inc · Sunrise, FLNon-citizen corporation, flight hours not reportedBuilt 1974 · S/N 402B0562 N402WWPark Avenue Group Inc · Stuart, FLS/N 402B1061 N403AJAero Jet Aviation I Inc · Fort Lauderdale, FLBuilt 1972 · S/N 402B0305 N403RMUlpiano Amy L · Carolina, PRS/N 402B0836 N4076QSandoval Juan · Valley Stream, NYBuilt 1968 · S/N 401-0176 N407RKMoore John C · San Miguel, CABuilt 1968 · S/N 401-0181 N4123TRace Dean · Chicken, AKBuilt 1966 · S/N 320D0023 N4130TSteven J Leavitt · Avondale, AZS/N 320D0030 N4135TNehls Chevrolet Olds Cadillac · Marshall, TXBuilt 1965 · S/N 320D0035 N4138TLindquist Holdings LLC · Noblesville, INBuilt 1965 · S/N 320D0038 N4154TNunya Business LLC · Middletown, DES/N 320D0054 N4156TRichard Brady K · Farmers Branch, TXBuilt 1965 · S/N 320D0056 N4159TGholami Amir H · Santa Rosa, CABuilt 1965 · S/N 320D0059 N4163TKasper Heath · Albany, ORS/N 320D0063 N4167GW J Medical Consulting · Caguas, PRBuilt 1976 · S/N 402B1214 N4169GNewell Henry O Jr · Roxboro, NCS/N 402B1215 N4181TKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1966 · S/N 320D0081 N4186TRegistered aircraftBuilt 1966 · S/N 320D0086 N41GDValiair Lc Trustee · Casper, WYS/N 401B-0218 N420HLJannelli Gilbert DBA · Clearwater, FLExpired dealerS/N 402B-0335 N420WBMcgregor Springs Square LLC · Mc Gregor, TXS/N 320F-0030 N42NCCapair Inc · Plantation, FLBuilt 1973 · S/N 402B0387 N444HTTaktos Ltd · Corvallis, ORBuilt 1973 · S/N 310Q0739 N44DPD L S Aviation Inc · Wilmington, DEBuilt 1968 · S/N 310P0039 N4537QInstant Security Service Inc · Wilmington, DEBuilt 1972 · S/N 402B0343 N4550QIsland Wings Inc · Fort Lauderdale, FLBuilt 1969 · S/N 402A0050 N455XTreat-Yo-Self Confections Inc · Corona, CABuilt 1973 · S/N 310Q1007 N45KPColvin Clu D DBA · Big Cabin, OKBuilt 1971 · S/N 401B0201 N47SPDurham Rex L · Blakely, GABuilt 1969 · S/N 310P0176 N503NAClover Park Technical College · Lakewood, WAS/N 402B-0313 N550FSRegistration Pending · Sheboygan Falls, WIRegistration pendingBuilt 1968 · S/N 401-0289 N566AGarrett Flying Service Inc · Danbury, TXBuilt 1965 · S/N 320D0062 N5740MSiemens Jonathan · Seminole, TXBuilt 1968 · S/N 310P0040 N5742MAmerican Aerial Survey Inc · Rancho Murieta, CABuilt 1968 · S/N 310P0042 N5752MColeman William J · Redondo Beach, CABuilt 1968 · S/N 310P0052 N5763MStan Hill Aviation LLC · Waterford, MIBuilt 1969 · S/N 310P0063 N5765MBush Abe A · Eatonton, GABuilt 1968 · S/N 310P0065 N5770MBallard Aviation Inc · Newton, KSBuilt 1968 · S/N 310P0070 N5793MCoxbill Farms Inc · Torrington, WYBuilt 1969 · S/N 310P0093 N5800MRidgewood Associates Inc · Nevada City, CAS/N 310P0100

Back to AD 70-03-04 R1