OpenAirDocs.org
AD 2004-21-08 R1

Registered aircraft · 511

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
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:2004-21-08-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:2004-21-08-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.

N437Sackett Scott H · Krum, TXBuilt 1952 · S/N 7930N4371NCole David L · Granbury, TXBuilt 1947 · S/N 7035N4373NApple Jeffrey G · Sheridan, INBuilt 1947 · S/N 7033N4374VBrown Robert A · Peachtree City, GABuilt 1949 · S/N 7289N4375VPeck Nathan Mark · Leavenworth, KSBuilt 1949 · S/N 7320N4380NWarwick Dakota R · Jupiter, FLS/N 7026N4383VPorter Charles R · Ocala, FLBuilt 1949 · S/N 7305N4384VBennett Robert M · Felton, DEBuilt 1949 · S/N 7306N4385NVyfvinkel Frederick J · New Smyrna Beach, FLBuilt 1947 · S/N 7019N4386VAlerion Aviation LLC · Elbert, COBuilt 1949 · S/N 7308N4388VPhilbrick Rodney C · Bishop, CABuilt 1949 · S/N 7310N4391NRoy Rodney E · Grand Marais, MNBuilt 1947 · S/N 7030N4392VKeith Harry E III · Coffeyville, KSBuilt 1949 · S/N 7343N4394NEnnis Shannon E · Chesapeake, VABuilt 1947 · S/N 7011N4395VAbel John R · Haslet, TXBuilt 1949 · S/N 7323N4398NHammerle Tye F · Kenosha, WIBuilt 1947 · S/N 7007N4400CLange Marc B · Spokane Valley, WABuilt 1952 · S/N 7985N4401CAsher Mitchell J · Senoia, GABuilt 1952 · S/N 7986N4402CMclain Daniel E · Baden, PABuilt 1952 · S/N 7987N4403CArlins Aircraft Service Inc · Belgrade, MTBuilt 1952 · S/N 7988N4405CDavis Richard L · Everett, WABuilt 1952 · S/N 7990N4408CBarron Aviation LLC · Perry, MOBuilt 1952 · S/N 7993N4411CBartko Ramon · Pittsburg, TXS/N 7996N4413CSteele Aviation Inc · Walnut Cove, NCS/N 7998N4414CJohnson Thomas W · Westminster, MDBuilt 1953 · S/N 7999N4415CHunter Mason B · Helena, MTBuilt 1952 · S/N 16000N4420CMilton William H · Amsterdam, NYBuilt 1952 · S/N 16005N4421CLake City Aero Ltd LLC · Grenada, MSBuilt 1953 · S/N 16006N4424CCollard Mark · Montague, MIBuilt 1953 · S/N 16009N4425CShipman Jared K · Bismarck, MOBuilt 1953 · S/N 16010N4426CAllen Stephen W · Fredericksburg, TXBuilt 1953 · S/N 16011N4427C28 North Plus LLC · New Smyrna Beach, FLBuilt 1962 · S/N 16012N4432CC & J Aviation Of Arkansas LLC · Flippin, ARBuilt 1952 · S/N 16017N4434CNewberg Edgar T · Hector, MNBuilt 1953 · S/N 16019N4438CCiabattoni Joseph L · Upland, CABuilt 1953 · S/N 16023N4439CRegistration Pending · Wilmington, DERegistration pendingBuilt 1953 · S/N 16024N4444CLester Chad M · New Castle, DEBuilt 1953 · S/N 16029N4448CSnider Gary · West Des Moines, IABuilt 1953 · S/N 16033N4453CKesinger Steven W · Fremont, CABuilt 1953 · S/N 16038N4455CJohnson Kyle A · Cheshire, CTBuilt 1952 · S/N 7965N4458CMarken Jeffrey R · Baker, FLBuilt 1953 · S/N 16043N4459CHankins Shannon G · Tulsa, OKBuilt 1953 · S/N 16044N4467CNighthawk Air Systems Inc · Palmetto Bay, FLS/N 16052N4468CCommand Aire LLC · Sitka, AKBuilt 1953 · S/N 16053N4469CDenair Inc · Clifton Springs, NYBuilt 1953 · S/N 16054N4474CSlipshod Aviation LLC · Hurricane, UTBuilt 1953 · S/N 16059N4476CBoatman C L · La Porte, TXBuilt 1953 · S/N 16060N4480CTupelo Aeronautics Inc · Tupelo, MSBuilt 1953 · S/N 16064N4484CHoward William D · Coupland, TXBuilt 1953 · S/N 16068N4486CUniversity Bancorporation Inc · Downers Grove, ILBuilt 1954 · S/N 16070
Back to AD 2004-21-08 R1