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.
N421SARedbreast Aviation LLC · Boonton, NJN421SGElevate Our Vetrans Ltd · Meridian, IDN421SWProuty Eric A · San Jose, CAN421TMcconnell Raymond F · Stratton, CON421TWHeslin Jon L · Sutton, MAN421YKearns Homer C III · Granbury, TXN422Datum Aviation LLC · Milton, FLN42202Palmer Charles L · Huntington Beach, CAFirst renewal noticeN42204Conservation Aviation LLC · Washington, DCN42206Jones Brian William · Portland, ORN42209Smith Patrick G · Wenatchee, WAN4220GVoorhies Danny L · Albertville, ALN4220HHutchinson Keith M · Lancaster, TXN4220JHisghman Jonathan G · Waynesboro, VAN4220QWhitefish Aero Services LLC · Crosslake, MNN4220ZLonon Michael E · Yuba City, CAN42212Caves Xxi Properties LLC · Virginia Beach, VAN42219Beck Daniel Joseph · Tuscaloosa, ALN4221DAntique Preservation Associaiton Of Greenfield · Greenfield, IAN4221JKeystone Aviation LLC · Melrose, FLN4221QRegistered aircraftN4221TEralet Inc · Middletown, DEN4221ZBlue River Aviation LLC · Palmer, AKN4222Barry Edwin R · Apple Valley, CAN4222HCre Aviation Holdings LLC · Ramona, CAN4222JHerrera Justin C · Willits, CAN4222QBearlodge Spray Foam & Coatings LLC · Sundance, WYN4222THeuer Daniel C H · Kindred, NDN42232Wheater Eric Alexander · King George, VAN42234Vp Niagara Aviation LLC · Niagara Falls, NYN4223JMccormick Brian C · Irvine, CAN4223ZHartman Brian D · Anchorage, AKN4224Reeves Arthur Arlo · Mendocino, CAN42241Peters Dale M · Naknek, AKN42242Beats A Flush LLC · San Diego, CAN42247Kratz Jeffrey B · Seattle, WAN4224QPressley Aviation LLC · New London, NCN4224TKhair Air Aviation LLC · Senoia, GAN42251Ada Forestry Division · Malvern, ARN4225NRy Cor LLC · Stevens Point, WIN4225TCulpepper Steven F · Columbus, GAN42261Shenandoah Skies LLC · Harrisonburg, VAN42262R And E Aviation LLC · Laurel, MSN42267Eischens William L · Alexandria, VAN42269Gabel Paul D · Canyon, TXN4226JSullivan Stephen G · Mize, MSN4226QVolatile Aero Ventures LLC · Boulder City, NVN4226TElledge William L · Glen Saint Mary, FLN42273Reeds Pharmacy LLC · Berkeley Springs, WVN42275Nelson Frank H · Tuscaloosa, AL
Back to AD 2007-04-19 R1