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.
N265HPN265hp LLC · Parachute, CON265JPN265jp LLC · Mill Valley, CAN265KBCedaron Medical Inc · Davis, CAN265MATrevathan Max Tyler · Braggadocio, MON265MESunset Leasing Inc · Sarasota, FLN265MGGeorgia Aviation Authority · Eastman, GAN265MHHarrington Michael · Twin Falls, IDN265NDAri Ben Aviator Inc · Fort Pierce, FLN265PCSilver Eagle II LLC · Carson City, NVN265PLAdams Aviation Services Inc Trustee · Wilmington, DEN265SFAb Prop Plane I LLC · Metairie, LAN265TWYale Companies LLC DBA · Indianapolis, INN265WGelinas Peter L · Burien, WAN265WYGemini Aviation LLC · Holmdel, NJN2660Applegate Land Holdings LLC · Jacksonville, ORN26601Trowbridge Rodney L · Haysville, KSN26602Eastern New Mexico University - Roswell · Roswell, NMN2660AN62689 Inc · Texarkana, TXN2660FWheels Up Aviation Inc · Lewes, DEN2660GFruge Cory · Egan, LAN2660PAnderson William B · Rogers, ARN2660QSummit Aviation LLC · Spokane, WAN2660RPa Bo Ma Inc · Alexandria, LAN2660WDeptula John R · Pinehurst, NCN2660YRam Aviation LLC · Palmer, AKN26613Coomes Thomas R · Hollis, OKN26616Sea Wing LLC · Camarillo, CAN26619Sides Michael E · Bartley, NEN2661ABerry Scott F · Destin, FLN2661QAlred Robert I · Barrow, AKN2661TSix One Tango LLC · Pismo Beach, CAN2661YAlaska Outdoor Consultants LLC · King Salmon, AKN2662ARogers Construction Services Inc · Boca Raton, FLN2662BGjl Aviation LLC · Fort Worth, TXN2662FGarmin International Inc · Olathe, KSN2662GWhitman Monty · Pagosa Springs, CON2662TPlane Aviation LLC · Camarillo, CAN2662WEaton Mark E · Houston, TXN2662XTail Aero Corp · Wilmington, DEN2662ZBidcal Inc · Chico, CAN26630Iasco Flight Training Inc · Redding, CAN2663JN2663j LLC · Rehoboth Beach, DEN2663PHoffrage Michael B · Fresno, CAN2663QBerg Weston L · Stanton, NDN2663XAvolant Aviation LLC · Mooresville, NCN2663ZVaccaro Glen J · Trinidad, CON2664Lcj Holdings LLC · Youngsville, LAN2664AZmuda Bruce V · Eagle River, AKN2664FWisconsin Aviation Inc · Watertown, WIN2664KPeters Jeremy D · Nampa, ID
Back to AD 2007-04-19 R1