AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N4990JEstes Aviation LLC · Vicksburg, MSN4990LCc Aero Services LLC · Bullard, TXN4990PCrux Logistics & Consulting Ltd · Las Vegas, NVN4990UBoard Of Regents Of The University Of Oklahoma · Norman, OKN4990WKennedy Terry P · Kingman, AZN4991FChouinard Christopher P · Friday Harbor, WAN4991GAlderman Melvin R · Jacksonville, FLN4991LStrickland Sterling S · Sammamish, WAN4991MOakview Homes LLC · Sullivan, MON4991REast Side Mosquito Abatement District · Modesto, CAN4992DSkydive Cross Keys LLC · Williamstown, NJN4992JBas Part Sales LLC · Greeley, CON4992LGrove City Aviation LLC · Mercer, PAN4993DPoole Jason · Quanah, TXN4993LEagerton Aviation LLC · Florence, SCN4993NBryant Kenneth D · Black Diamond, WAN4993PHatch George R · Avon, MAN4993WHamilton Robert A · Owensboro, KYN49948Stuart George G · Maceo, KYN4994ARose Carey V · Colville, WAN4994ELaforest David C · Hudson, MIN4994FClark William R · Anchorage, AKN4994JCrowe Justin L · Tompkinsville, KYN4994KMenefee Jerry V · Carson City, NVN4994RCountry Air Service Inc · Hecla, SDN4994SSmith Thomas C · Norfolk, VAN4995BStobbe Marlin L · Granada Hills, CAN4995FSkorina Frank K · Walla Walla, WAN4995SNova Aero LLC · Ontario, ORN4996JLee Matthew · Magnolia, TXN4996LConverse Alan W · Garfield, KSN4996SChabrian Jerry W · Daytona Beach, FLN4997PBrown Tyler Cooper Trustee · Anchorage, AKN4998AWright Transport Inc · Colfax, INN4998DWood Andrew A · Clifton Springs, NYN4998GOdenbach Eric J · Eureka, SDN4998USixty Five Two Ten LLC · Oak Island, NCN4999CKipp Russell · Meadow, TXN4999DMielke Martin W · Valley City, OHN4999FHarrington Jennifer L · Minneapolis, MNN4999LKnox Mark M · Thornton, PAN4999MStolutions LLC · Lexington Park, MDN4999SStaples Chad V · Efland, NCN4999TAndy Aviation Inc · Live Oak, FLN499CAHyannis Air Service Inc · Hyannis, MAN499CPCivil Air Patrol · Maxwell Afb, ALN499CRAce Tomato Company LLC · Daytona Beach, FLN499DCConrad David J · Wausau, WIN499DLCjrr Consulting LLC · Denver, CON499DPFarrington John R · Cedar Park, TX
Back to AD 2007-04-19 R1