AD 80-07-06
Registered aircraft · 264
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:80-07-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-07-06')
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:80-07-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-07-06') 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.
N6007FMobley Barbara Alice · Kathleen, GAN6007TMinton Richard D · Longville, LAN6011QHikari Aviation Ltd · Torrance, CAN6011UJin Jin Aviation LLC · Anchorage, AKN6013ZVandelay Aviation LLC · San Diego, CAN60156Shannon School Of Aeronautics LLC · Fredericksburg, VAN6015QBohlke LLC · Kingshill, VIN6015ZOsorio Aviation Corp · Miami, FLNon-citizen corporation, flight hours not reportedN6016UAbbasi Babak · Escondido, CAN60199Krystofiak Steven · Scottsdale, AZN601RKNorthampton Aeronautics Inc · Northampton, MAN60244Ace Of Spades Aviation LLC · Las Vegas, NVN60405Aero Quest LLC · Olive Branch, MSN6041UCentral Virginia Aviation Inc · Petersburg, VAN6042FFly Aviation Corp · Wilmington, DEN6043YFreeman Eugene P · Paducah, KYN60451Jkg LLC · Murfreesboro, TNN6049LExecutive Flight Institute LLC · Murrieta, CAN610WMWilber Christian B · Waukesha, WIN6199XH&S Aviation LLC · Chesapeake, VAN641PSSmith Michael J · Napa, CAN650THAri Ben Aviator Inc · Fort Pierce, FLN6625DFox Valley Technical College · Oshkosh, WIN66265Russo James F · Hilton Head Island, SCN66272Fox Valley Technical College · Oshkosh, WIN6627XIsiah 4031 LLC · Quakertown, PAN6628XAtlanta Aviation Academy Inc · Lawrenceville, GAN6628YAri Ben Aviator Inc · Ft Pierce, FLN66301Guidry David Brian · Lake Charles, LAFirst renewal noticeN6630TRoberts Joshua E · Pike Road, ALN6632JSo Cal Leasing LLC · El Cajon, CAN6632UFox Falley Technical College · Oshkosh, WIN66339Ave Marina Aviation Co · Long Beach, CANon-citizen corporation, flight hours not reportedN66340Wickline Wayne · Flower Mound, TXN6634BAri Ben Aviator Inc · Fort Pierce, FLN66352Seaplane Adventures LLC · Cheyenne, WYN6635BChandler Jerome P · Redondo Beach, CAN6636LAoa Kissimmee Inc · Kissimmee, FLN6636TVincent Air LLC · Carroll, IAN6637RSchawang Darrin E · Falls City, NEN6638HWright Aero Inc · Saint Cloud, MNN6638LNewby Danny A · Mc Leansville, NCN6697DAtlanta Aviation Academy Inc · Lawrenceville, GAN6698HNational Test Pilot School · Mojave, CAN66TPAmerican Aviation Aircraft Leasing Inc · El Cajon, CAN67000Registration Pending · Johns Island, SCRegistration pendingN6700CKelly Aviation & Investigation LLC · Vail, AZN6701RAirplane And Drone Flight Instruction LLC · Orlando, FLN6701TAtlanta Aviation Academy Inc · Lawrenceville, GAN6701VHub City Aviation Academy LLC · Lubbock, TX
Back to AD 80-07-06