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.
N3809UMartus Michael · Russellville, OHN3809YShaffer Kent R · Sour Lake, TXFirst renewal noticeN3809ZHelm Charles M · Darlington, WIN3812CChristiansen Aviation LLC · Wilmington, DEN3812QN3812q LLC · San Diego, CAN3812UBasquit Kenneth H · Pittsburgh, PAN3818ZRigney Mark E · Ponca City, OKN383Martis Valley Aviation LLC · Redwood City, CAN38384Baisden James Brett · Manassas, VAN38397Registered aircraftN3839LFlight School Of Gwinnett · Lawrenceville, GAN38462Krystofiak 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, CAN42RRWalla Walla University · College Place, WAN444FEN444fe LLC · Stuart, FLN456THB R S Leasing Inc · Wilmington, DEN4818FCragg Philip A · Point Roberts, WAN5017MNo Limits Aviation Inc · Lincoln, MTN5090MAri Ben Aviator Inc · Fort Pierce, FLN5116MBend Aircraft Mechanics LLC · Bend, ORN5164MChristiansen Aviation LLC · Wilmington, DEN5166MSun City Aviation LLC · Davie, FLN516MSSouth Bay Aviation Inc · Torrance, CAN5183MGc Aviation Services 1 LLC · Miamisburg, OHN5194MSunstate Aviation Inc · Kissimmee, FLN5236MAri Ben Aviator Inc · Fort Pierce, FLN5283MPskd Limited LLC · Upland, CAN5485MN446rh LLC · Helena, MTN54VBas Part Sales LLC · Greeley, CON559MKBadawi Aviation LLC · Orlando, FLN577FCFlight Club · Middle River, MDN57RTChristiansen Aviation LLC · Wilmington, DEN59DLChannel Islands Aviation Inc · Camarillo, CAN6001KAllred Warren D · Marshfield, MON6001RSorbi Aviation Inc · El Cajon, CAN6001YPilots Choice Aviation Equipment Leasing Co · Georgetown, TXN6002CChristiansen Aviation LLC · Wilmington, DEN6002KJet & Rotor Aviation LLC · Sacramento, CAN6002LBadawi Aviation LLC · Orlando, FLN6003RRemikin I LLC · Naperville, ILN6003YAri Ben Aviator Inc · Fort Pierce, FLN6006DLedda Francesco · Canton, TX
Back to AD 80-07-06