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.
N261CCCook Christopher · Columbus, GAN261DMOelmann Dennis J · Waverly, IAN261DRSafeflite Aviation LLC · Glenwood, IAN261EABrownstone Aviation II LLC · Houston, TXN261EMJeffrey Brian Cooper · Poway, CAN261EPEpic Aviation Inc · Denison, TXN261EZZokpodo Emmanuel K · Sacramento, CAN261FAStratus Rr LLC · New Castle, DEN261FCVu Ai · Aiea, HIN261GVBohn Jim A · Mead, WAN261HHoward Clifford E · Auburn, WAN261JBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN261KTFrisch Adam · Los Angeles, CAN261MGGeorgia Aviation Authority · Eastman, GAN261MMCockroft Scott · Kersey, CON261REPeterson Randy J · Sonoma, CAN261RMOlandese Donald J · Newalla, OKN261SBird Frank III · Jennings, FLN261SCIndia Aviation LLC · Oregon City, ORN261SSScopellite Sebastian · Phoenix, AZN261VFBickley Clarence R · Jefferson, GAN261WYFoss Jared K · Greenbush, MNN261XEvans Dennis · Naples, FLN26206Breakey Phillip · Pickerington, OHN2620CWhalen Shenandoah · Amelia, OHN2620FWood Don B · Centerville, UTN2620GBas Part Sales LLC · Greeley, CON2620MBooth Chance · Wasilla, AKN2620QAkroyd Robert F Jr · Raton, NMN2621FGallaher Boyd H · Prescott, AZN2621GAdamic David J · Cedar Hills, UTN2621KBasmajian Zachary Robert · Peoria, AZN2621MWestern Oklahoma Aviation LLC · Clinton, OKN2621QBrown Russell C · Howey, FLN2621ZWifa (Washington International Flight Academy) LLC · Gaithersburg, MDN26225Kilday Klayton D DBA · Dexter, ORN2622FFlying Wolves Inc · Arnegard, NDN2622GKaplan Steven M · North Monmouth, MEN2622HBurgess John H · Tower, MNN2622MN2622m LLC · Rehoboth Beach, DEN2622TStenvers Aaron · Valley, NEN2622WMohamed Eman Z · Lubbock, TXN2622YPiatt Matthew D · Wasilla, AKN26234Compositec Inc · Manitowoc, WIN26236Mcdonnel Jack Edward Jr · Woodsboro, TXN26237Registration Pending · Spokane, WARegistration pendingN26239Rice Grantland S · Boston, MAN2623BWalton Indy R · Soldotna, AKN2623CDodson International Parts Inc · Rantoul, KSN2623GHubbard James D · Jacksonville, TX
Back to AD 2007-04-19 R1