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.
N4948GTrece Inc · Adair, OKN4948QWhite Ronald A · Anchorage, AKN4948RBlain Monte W · Joliet, MTN4948STaildragon LLC · Albuquerque, NMN4948URegistered aircraftN4949ASw Air LLC · Denver, CON4949ETrans Crafts LLC · Big Lake, AKN4949GFalcon Aviation LLC · South Saint Paul, MNN4949LLim Young Keun · Carthage, MON4949NCompass Rose Aviation · Derby, KSN4949PSonn Jeffrey R · Descanso, CAN4949RValley Flying Service Inc · Orleans, NEN494AStotlar William B · Pinckneyville, ILN494ABGluff Alan D · Franklin, INN494AMOsprey Holding Company LLC · Foley, ALN494BEBig Ego Aerobatics Inc · Naperville, ILN494CMLeadership In Training Education Inc DBA · Apollo Beach, FLN494DSBeulah Ltd Trustee · Wilmington, DEN494DWVieira Mark T · Turlock, CAN494EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN494FLWilliams Mark J · Ojai, CAN494HSale Reported · West Palm Beach, FLSale reported, pending cancellationN494JBD & S Aviation LLC · Spring, TXN494JGGallagher Joseph Leo · Reno, NVN494LAPiper 3 LLC · Chestnut Ridge, NYN494LWWitte Steven E · Egan, SDN494PGarrett Jacob Y · West Plains, MON494PCChristensen Darrel W Jr · Soldotna, AKN494RJIsaacson Keith B · New Orleans, LAN494RVBerthold Myles A · Belleville, ILN494SHIhde Investments Lp · Red Oak, TXN494SPInternational Air Services Inc Trustee · Carson City, NVN494TMDuke Flight Training LLC · Bonnyman, KYN494TSDeep Creek Lake Ventures LLC · Oakland, MDN494WKingsbury Raymond S · Farmington, MNN494WAFly More Inc · Kawkawlin, MIN495495htsi LLC · Wilmington, DEN4950DSimpson Darrell W · Soldotna, AKN4950HVaivadas Brian S · Bonney Lake, WAN4950LDesimone Joseph L · Castle Rock, CON4950RCivil Air Patrol Inc Natl Hdqtrs · Maxwell Afb, ALN4950UAerotech Mapping Inc · Las Vegas, NVN4950ZRiverside Tractor Inc · Friendswood, TXN49516Bresson Flying Service Inc · Compton, ILN4951FAerial Services Inc · Cedar Falls, IAN4951GMelbourne Flight Training LLC · Melbourne, FLN4951LMetcalf Linda G · Amarillo, TXN4951NCactus Av8rs LLC · Gilbert, AZN4951PKnights Aviation Services LLC · Westlake, OHN4951TVolaero Aviation LLC · Valdosta, GA
Back to AD 2007-04-19 R1