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.
N277LTBeechnutz Aviation LLC · Atlanta, GAN28FCFlight Club · Middle River, MDN298BCFlight School Of Gwinnett · Lawrenceville, GAN312CMChristiansen Aviation LLC · Wilmington, DEN329GBN329gb LLC · Chattanooga, TNN331GZN331gz LLC · Fort Myers, FLN359MJSkyway Leasing Inc · Lakeland, FLN3692XLake Elmo Aero LLC · Lake Elmo, MNN3706WAshby Sharon · Flora, INN3707BSampson Gary W · Cedar Rapids, IAN3707GHooker Kenneth R · Sheridan, ARN3711NBay Area Concrete LLC · Hayward, CAN371AKSweeney James J III · Glenwood Springs, CON3724BFlorida Flyers Flight Academy Inc · Saint Augustine, FLN3724HAviation Capital Management LLC · San Jose, CAN37259Krystofiak Steven · Scottsdale, AZN3725XShultz L E · Brentwood, TNN3726BThomas Allen Lee · Cedar Rapids, IAN3726UPillor Dalton John · Surprise, AZN37275Sky West Aviation Inc Trustee · Albuquerque, NMN37276Fedorenko Vladimir Y · Estacada, ORN3727BLonghorn Holding LLC · De Pere, WIN3728GDodson International Parts Inc · Rantoul, KSN3729BFredericks William D · Charleston, WVN3729DLambert David C · Conway, ARN3730NHealy David Paul · Arlington, TXN3730SWingfield Ronald T · Little Rock, ARN3731BSf-Gb Enterprises · Shelbyville, KYN3732BMurphy Walter D Trustee · Newcomerstown, OHN3732FInderwiesen Nancy A · Cleveland, MON37332Shay Jonathan P · El Cajon, CAN3733CBarber Ted · Huntington, NYFirst renewal noticeN3733DSt Charles Flying Service Inc · Portage Des Sioux, MON3733GPilots Choice Aviation Equipment Leasing Co · Georgetown, TXN37345Southern Aircraft Consultancy Inc Trustee · Casper, WYN3735RJones Larry L · Paragould, ARN3737UAirria Holdings LLC · BerlinN3739QN3739q LLC · Colleyville, TXFirst renewal noticeN3740BWood Graham A · Marshall, WIN377FCFlight Club LLC · Middle River, MDN37997Flying Brick LLC · Monroe, NCN3801RFial Ronald A · Milwaukie, ORN38024Hancock Aviation LLC · Baton Rouge, LAN38025Missaukee Aircraft Leasing LLC · Cadillac, MIN38026Terra Scott M · Vacaville, CAN3803ESorbi Aviation Inc · El Cajon, CAN38054Burr William L Jr · Johns Creek, GAFirst renewal noticeN38062Marquez Naoko Quena · Henderson, NVN3807KFaucette Micro Systems Inc · Fallon, NVN38086Autumn Crocus LLC · Cincinnati, OH
Back to AD 80-07-06