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.
N35789Barrett Robin C · Holwaloa, HIN3578FJag Flying Club Inc · Morgantown, WVN3578KWienhold Kevin · Cuyahoga Falls, OHN3578PTirrell Danielle J · Fairbanks, AKN3578ZNance Gary L · Fairbanks, AKN35790Integrity Aviation Inc · Worthington, MNN35795N35795 LLC · Fredericksburg, TXN35798Big Sky Aviation LLC · Massillon, OHN35799Huebner Otto · Bolingbrook, ILN3579APerry John E · Kenai, AKN3579BEssman Kenneth R · Burlington, WIN3579FRoberts David J · Missoula, MTN3579NPorter Gary · Oregonia, OHN3579UIou Aviation LLC · Sheridan, WYN3579WGuzman Anthony J · Hacienda Heights, CAN3579YReal Property Services LLC · Bentonville, ARN3579ZMartin Michael J · Anchorage, AKN357AFour Leaf Air LLC · Cedar, MIN357AHAtlantic Aviation International Inc · Lewes, DEN357ASAero Leasing Inc · Medford, ORN357AUWeakley Robert Kayce · Pleasant View, TNN357BCChristopher Brian A · Panama City Beach, FLN357BGBowling Green Flight Center LLC · Bowling Green, OHN357BKStone Michael · Palatka, FLN357BUGilbert Jeffrey T · Tucson, AZN357CEWindh Steven R · Reedley, CAN357CMHanson Hans E · Anchorage, AKN357CPCivil Air Patrol · Maxwell Afb, ALN357CSN357c5 LLC · Clinton, MON357DRegis Frederic · Denver, CON357DBBecker Mark D · Bismarck, NDN357DGRegistered aircraftRegistration pendingN357DSBentley David K · Omaha, NEN357DWFlight Training Aircraft LLC · Wilmington, DEN357EBSky Solutions LLC · Detroit, MIN357ESReeno Aviation LLC · Lewisville, NCN357GHHall George D · Camilla, GAN357HMH & M Aviation LLC · Madison, MSN357JAEagle Aviation LLC · Indianapolis, INN357JPNovember Alpha LLC · Los Angeles, CAN357JTClub Bo A36 LLC · Helena, MTN357JWWoods Jim W · Lodi, CAN357KFAirmart Inc · Lexington, KYN357KKDkk LLC · Indian Rocks Beach, FLN357KSStanley Kenneth L · Cape Coral, FLFirst renewal noticeN357LCSkywagon Ventures LLC · Anchorage, AKN357LHElite Aerial Photography Inc · Naples, FLN357LZAv8 Flight Assets LLC · Eden Prairie, MNN357MMcelroy Ronald D · Las Cruces, NMN357MEMichigan Dept Of Natural Resources · Roscommon, MI
Back to AD 2007-04-19 R1