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.

N6628XAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1979 · S/N ME-218 N6628YAri Ben Aviator Inc · Ft Pierce, FLBuilt 1979 · S/N ME-219 N66293Maine Instrument Flight · Augusta, MEBuilt 1979 · S/N MC-674 N6629RDempsey Yvonne Grace · Guys Mills, PABuilt 1975 · S/N M-1609 N662KWDavis Daniel · Bloomington, MNS/N D-6389 N663Broken Arrow Crop Insurance Inc · Perryton, TXBuilt 1943 · S/N 4903 N66301Guidry David Brian · Lake Charles, LAFirst renewal noticeBuilt 1979 · S/N WA-29 N66303Holder Real Estate Services LLC · Pembroke, KYBuilt 1979 · S/N MC-676 N66304Schandelmeier Charles E · Melissa, TXBuilt 1979 · S/N MC-675 N6630RGamma2 Inc · San Diego, CABuilt 1974 · S/N MC-314 N6630TRoberts Joshua E · Pike Road, ALBuilt 1980 · S/N WA-107 N66313Brazon Brian D · Belle Vernon, PABuilt 1980 · S/N M-2192 N6631RCornelius Craig R · West Hartford, CTFirst renewal noticeBuilt 1974 · S/N MC-313 N6631SNot A Jet Yet LLC · Chandler, AZBuilt 1976 · S/N CE-627 N6631ZClark Ryan D · Sequim, WAS/N M-2190 N6632CJocz Douglas D · Jeffersonton, VABuilt 1983 · S/N CE-1017 N6632JSo Cal Leasing LLC · El Cajon, CABuilt 1980 · S/N ME-337 N6632LSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N M-2188 N6632UFox Falley Technical College · Oshkosh, WIBuilt 1980 · S/N ME-323 N66337Bales Robert · Osage Beach, MOBuilt 1979 · S/N M-2201 N66339Ave Marina Aviation Co · Long Beach, CANon-citizen corporation, flight hours not reportedBuilt 1979 · S/N ME-239 N6633FRegistration Pending · Moses Lake, WARegistration pendingBuilt 1979 · S/N M-2196 N6633RBlake Anthony B · Hallsville, TXBuilt 1979 · S/N M-2198 N66340Wickline Wayne · Flower Mound, TXBuilt 1979 · S/N ME-241 N66344Sallee Philip L · Yucca Valley, CABuilt 1979 · S/N M-2207 N6634BAri Ben Aviator Inc · Fort Pierce, FLBuilt 1979 · S/N ME-234 N6634MSherwood Matthew M · Independence, MOBuilt 1979 · S/N MC-682 N6634XPierson Rodney K Trustee · Redding, CABuilt 1979 · S/N MC-685 N66352Seaplane Adventures LLC · Cheyenne, WYBuilt 1979 · S/N ME-251 N66354Chesson Bradley S · Tacoma, WABuilt 1979 · S/N M-2214 N6635BChandler Jerome P · Redondo Beach, CABuilt 1979 · S/N ME-245 N6635DGooderum Mark P · Excelsior, MNBuilt 1979 · S/N MC-668 N6636DAnderson James M · Little Rock, ARS/N MC-690 N6636LAoa Kissimmee Inc · Kissimmee, FLBuilt 1979 · S/N ME-256 N6636TVincent Air LLC · Carroll, IABuilt 1979 · S/N ME-259 N6637EOddo Dominick · Mahopac, NYBuilt 1979 · S/N MC-692 N6637RSchawang Darrin E · Falls City, NES/N WA-35 N6637ZTye Barry · Opelika, ALBuilt 1979 · S/N MC-693 N6638BAhmed Gedi A · Saint Paul, MNS/N M-2217 N6638HWright Aero Inc · Saint Cloud, MNBuilt 1979 · S/N ME-266 N6638LNewby Danny A · Mc Leansville, NCBuilt 1979 · S/N WA-37 N6639DBig Bend Community College · Moses Lake, WABuilt 1979 · S/N M-2223 N663DBCharles Self Enterprises LLC · Minden, LABuilt 1953 · S/N AF-53-4119 N663TBMcmillan Peter H · San Francisco, CABuilt 1964 · S/N BA-663 N66409Dans Flying Service Inc · Crookston, MNBuilt 1979 · S/N D-10261 N6640LHyder Steven Richard · Albuquerque, NMBuilt 1979 · S/N D-10257 N6640UDc Air Corp · Aventura, FLBuilt 1979 · S/N E-1537 N6640XCentral Pennsylvania Aircraft Leasing LLC · Boiling Springs, PABuilt 1979 · S/N E-1532 N6641CMacdougall Jamie L · Pls Vrds Est, CABuilt 1979 · S/N E-1542 N6641MBecker Franklin B · Phillipsburg, NJBuilt 1979 · S/N E-1545

Back to AD 99-05-13 R1 WD