AD 80-07-07
Registered aircraft · 113
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-07')
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-07')
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-07') 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-07') 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.
N38025Missaukee Aircraft Leasing LLC · Cadillac, MIN38026Terra Scott M · Vacaville, CAN38054Burr William L Jr · Johns Creek, GAFirst renewal noticeN38062Marquez Naoko Quena · Henderson, NVN3807KFaucette Micro Systems Inc · Fallon, NVN38086Autumn Crocus LLC · Cincinnati, OHN3809UMartus Michael · Russellville, OHN3809YShaffer Kent R · Sour Lake, TXFirst renewal noticeN3809ZHelm Charles M · Darlington, WIN3812QN3812q LLC · San Diego, CAN3812UBasquit Kenneth H · Pittsburgh, PAN3818ZRigney Mark E · Ponca City, OKN38384Baisden James Brett · Manassas, VAN38397Registered aircraftN38462Krystofiak Steven · Scottsdale, AZN3846UKrystofiak Steven · Scottsdale, AZN3851ZPurcell Jmes Patrick III · Bayville, NJN3857DGill Michael T · Little Rock, ARN3860BFlight Club LLC · Middle River, MDN38644Harper Benjamin F III · Greensboro, ALN3868JParker Fred E · Portola, CAN3868KBeaver Mark · Valparaiso, INN3870UJsn Aviation LLC · Huntersville, NCN400RLJacobsson Charles A · San Gabriel, CAN4818FCragg Philip A · Point Roberts, WAN577FCFlight Club · Middle River, MDN6001KAllred Warren D · Marshfield, MON6007FMobley Barbara Alice · Kathleen, GAN6007TMinton Richard D · Longville, LAN60199Krystofiak Steven · Scottsdale, AZN6043YFreeman Eugene P · Paducah, KYN610WMWilber Christian B · Waukesha, WIN66301Guidry David Brian · Lake Charles, LAFirst renewal noticeN6630TRoberts Joshua E · Pike Road, ALN6637RSchawang Darrin E · Falls City, NEN6638LNewby Danny A · Mc Leansville, NCN6707MLouis & Clark Aviation LLC · Fort Myers, FLN6708XBaumbach James P · Lodi, CAN6709LBowlin Frank J · Santa Fe, NMN6711RAme Flight Holdings LLC · Oasis, IDN6713VMclendon Donnie E · Winder, GAN6715VByrds Wholesale Inc · Clayton, NCN6715YTrevitue LLC · Dripping Springs, TXN67169Arai Eisuke · San Jose, CAN6716SShelby Monroe Group LLC · Sioux City, IAN6718RVernier Deborah J · Goshen, KYN6719VDaniel Scott · Kingston, GAN67201Sale Reported · Sunman, INSale reportedN67217Pompano Hangars Inc · Lighthouse Point, FLN6721VNoll Brent M · Burbank, CA
Back to AD 80-07-07