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.
N293MJLittle Dock Aviation LLC · Water Valley, MSN293MSSenegal Steven L · San Bruno, CAN293NDChristiansen Aviation LLC · Wilmington, DEN293PCBank Of Utah Trustee · Salt Lake City, UTN293PEPhoenix East Aviation LLC · Daytona Beach, FLN293RCCharlie Papa Aviation LLC · Mayaguez, PRN293RLCunningham Clinton · Kissimmee, FLN293RVHaley Greg W · Frankston, TXN293SMKemp Aviation LLC · Hiram, GAN293SPNiemeyer Leasing LLC · Cave Creek, AZN293SRSykes Robert G · Hopkins, MNN293WBrooker John M · Sandersville, GAN293WCColorado Mesa University · Grand Junction, CON293WYRoth Jerry · Longwood, FLN29400Registration Pending · Wakefield, RIRegistration pending, pending cancellationN29409Nimmo David G · Ponder, TXN2940ABarnett David E Trustee · Anchorage, AKN2940FHarry Daye Aviation Services LLC · Surprise, AZN2940GDakota Air Spray LLC · Huron, SDN2940KRegistered aircraftN2940LFlyingchamp LLC · Missoula, MTN2940RRespass Keith D · Bluffton, SCN2940TKeller Vickie Rae · Arvada, CON2940VMike Koller Enterprises Inc · Wilmington, DEN2940YDi Giorgio Omar · Santa Fe, NMN2940ZMi Casa Apratment Corp · Mayaguez, PRN29415Dahlen Jeffrey P · Devils Lake, NDN2941BTaylor James Dean · Abilene, TXN2941LWells Joseph L · Ashburn, VAN2941PWeddle Curtis Eugene · Iowa Park, TXN2941TGiermek Peter T · Olean, NYN2941UBaldasaro John · Clifton Park, NYN29421American Aerial Scenes · Pompey, NYN29422Kmz Transport & Leasing Services LLC · Bradenton, FLN2942FSdc Aviation LLC · Fort Smith, ARN2942LMurphy Paul James · Falls Church, VAN2942RBright Michael R · Whitehall, MIN2942TCentral Minnesota Aviation LLC · Paynesville, MNN2942XLewellen Mark A · Pensacola, FLN2942ZHolloway Johnnie M · Laurel Hill, NCN29430Mcvicker Max W · Sand Springs, OKN29432Waddell Bhrent E Trustee · Collinsville, OKN29434Salvi Marcos · Phoenix, AZN29436Echelon Sport Aviation LLC · Los Angeles, CAN29439Eagle Sky Patrol Inc · Deadwood, SDN2943AGraham Jason J · Anchorage, AKN2943CBaas Brian · Cambridge, MNN2943DSouthern Aircraft Consultancy Inc Trustee · Casper, WYN2943PDriscoll Patrick J · Caldwell, IDN2943TN2943t LLC · Fort Myers, FL
Back to AD 2007-04-19 R1