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.
N34250Sierra Lima Aviation LLC · Riverton, UTN34258Urias Alejandro R · Mcallen, TXN34259Sharp Kenneth M · Pueblo, CON3425FJ A White & Son Aviation LLC · Powder Springs, GAN3425PCw Designer Homes Inc · Burnet, TXN3425SHoulihan John D · Wasco, CAN3425U4appraisals LLC · Odessa, TXN3425XY E Services Inc · Bradenton, FLN34265Clc Aviation LLC · Springfield, MON3426DGaither Timothy · Inman, KSN3426EJts Management Inc · Lincoln, NEN3426LCurtis Jeremy A · Fairbanks, AKN3426RCarter Thomas M · Macedon, NYN3426YMachnik Todd J · Old Lyme, CTN34271Globalsvc Aviation Group LLC · Coeur D Alene, IDN34273Downing Dennis L · Winter Haven, FLN34274Nast Thomas B · Seattle, WAN34275Bishop Nina A · Gig Harbor, WAN34276Conlogue Walt R · Wilmington, NCN3427MFlagiello Marissa Edwards · San Francisco, CAN3427NWackerle Timothy S · Marshall, MIN3427SNovember Sierra LLC · Lake Havasu City, AZN3427TRodgers Julia D · Orem, UTN3427WHurricane Air LLC · Fremont, OHN3427YTradewind LLC · Wasilla, AKN34281Newman Richard T · Everett, WAN34283Tropical Flying Club LLC · Orlando, FLN34284Ladd Michael · Umatilla, FLN34285Peterson Scott · Morgantown, WVN34286Pierce Ralph Anthony · Lake Mathews, CAN34287Satellite Beach Flying Club Inc · Melbourne, FLN34288Registration Pending · Lakebay, WARegistration pendingN3428FKcsi Aerial Patrol Inc · Bakersfield, CAN3428RLagrange David F · Winterset, IAN3428TBroken Arrow Crop Insurance Inc · Perryton, TXFirst renewal noticeN3428UHcp Aviation LLC · Waco, TXN3428ZHefner Ronald J · Plattsmouth, NEN3429EMelbourne Flight Training LLC · Melbourne, FLN3429ZWaters Dwayne R · Merritt Island, FLN342BFritz John R · Chester, MTN342BGBowling Green Flight Center LLC · Bowling Green, OHN342BJDaniel Junior · Wasilla, AKN342CAEastern Stearman Inc Trustee · Leesburg, VAN342DALewis William R · Temple, TXN342DBBeitler William · Washington, PAN342DFAero-Marine Services Inc · Wilmington, DEN342EAAfrican Inland Mission International · Peachtree City, GAN342FDCarver Mark D · Alma, GAN342FGDm Equipment Leasing LLC · Parker, CON342FSPetersen Aircraft Inc · Murdock, MN
Back to AD 2007-04-19 R1