Skip to content

AD 99-05-13 R1 WD

Registered aircraft · 13,518

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

N732BWalton Robert A · Des Moines, IABuilt 1948 · S/N D-1739 N732DCastaldi Justin W · Fresno, CABuilt 1953 · S/N D-3408 N732GMasterpiece Lc · Deland, FLBuilt 1969 · S/N D-9065 N7334BKiesznowski Craig C · Romulus, MIBuilt 1954 · S/N D-3797 N7334RSohail Air Ventures LLC · Orange, CABuilt 1974 · S/N TC-1697 N7335BWebb Anthony R · Earlsboro, OKS/N D-3798 N7338BMonpas Carol A · Novato, CABuilt 1954 · S/N D-3801 N7339RDoell Tom C · Dallas, TXBuilt 1974 · S/N E-563 N733ACHock Frederick · Waynesboro, VABuilt 1974 · S/N CE-499 N733BYUnited States Air Force Owner · Colorado Springs, COBuilt 1965 · S/N TF-55 N733RCStanly Business Consultants LLC · Albemarle, NCBuilt 1979 · S/N TC-2265 N733SEWaller Richard E · Marks, MSBuilt 1969 · S/N D-8919 N7340TThunderbird Flyers LLC · Steamboat Rock, IABuilt 1965 · S/N M-860 N7341BGauntt Drex · Pasco, WABuilt 1954 · S/N D-3804 N7344BCojocaru Nick · Crowley, TXBuilt 1954 · S/N D-3807 N7345RSale Reported · Crystal, MNSale reportedBuilt 1974 · S/N TC-1707 N7346RSeagull Flying Club Inc · San Jose, CABuilt 1974 · S/N E-569 N7347BCatawba Valley Community College Board Of Trste · Hickory, NCS/N D-3810 N7348RBerrey Andrew · Sandpoint, IDBuilt 1974 · S/N TC-1709 N7349RGettier Albert F Jr · Henderson, NVBuilt 1974 · S/N CE-507 N734BBallard William · Keller, TXBuilt 1948 · S/N D-1741 N7350BSievers Bradley M · Rayne, LABuilt 1954 · S/N D-3813 N7351BCrosswind Aviation Inc · Oakley, KSS/N D-3814 N7352BYu-Ga LLC · Munster, INBuilt 1954 · S/N D-3815 N7353BTownsend Patrick O · Stillwater, MNBuilt 1954 · S/N D-3811 N73548Smith Salvage And Restoration Services LLC · New Berlin, TXS/N A-548 N7355CGeneva Laes Aviation LLC · Lake Geneva, WIBuilt 1973 · S/N TE-925 N7356BMitchell Sharron J · Pewaukee, WIBuilt 1954 · S/N D-3819 N7357RWalter Charles T Jr · Ocala, FLBuilt 1974 · S/N E-571 N735BBLinger Daniel E · Chicago, ILBuilt 1958 · S/N D-5557 N735VThomas Stephen · Granbury, TXBuilt 1979 · S/N D-10262 N7363BJones N Earl Jr · Coats, NCBuilt 1954 · S/N D-3826 N7366RAndes David A · Fairborn, OHBuilt 1974 · S/N CE-514 N7367RMockingbird Aviation LLC · Wilmington, NCBuilt 1974 · S/N D-9638 N7368BSouthwest Aircraft Transportation And Recovery · Norco, CABuilt 1954 · S/N D-3857 N7368RCruiseair Aviation Inc · Ramona, CABuilt 1974 · S/N CE-510 N7369RDuman Ralph J · Cedarville, MIBuilt 1974 · S/N D-9650 N736BStone William T · Stratford, CABuilt 1958 · S/N D-5589 N7378BWagner Francis J · Anamoose, NDFirst renewal noticeBuilt 1954 · S/N D-3841 N7378RLarson Aviation LLC · Waukegan, ILBuilt 1974 · S/N CE-516 N737EDDuke Group LLC · Port Clinton, OHFirst renewal noticeS/N P-185 N737ELCsi Flight Services LLC · Mcminnville, ORS/N EA-127 N737MBSeven Mike Bravo LLC · Grand Haven, MIBuilt 1961 · S/N D-6764 N737PM & E Horizons LLC · Slatington, PABuilt 1994 · S/N E-2908 N737SMarc Inc · Bolton, MSBuilt 1969 · S/N TC-1297 N737SWAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1959 · S/N BA-402 N737VBoka Dale J · Clarkston, MIBuilt 1953 · S/N D-3457 N7381BCoffin J Park Jr · Knoxville, TNBuilt 1954 · S/N D-3844 N7386BAdams Gregory L · Lake Stevens, WABuilt 1954 · S/N D-3849 N7386RHebert William N · Angel Fire, NMBuilt 1974 · S/N TC-1729

Back to AD 99-05-13 R1 WD