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.
N33691Wide Open Aviation LLC · Kalispell, MTN33692Horn Justin L · Hearne, TXN33694Fly LLC · Natchez, MSN33698Briggs Michael L · Howell, MIN3369ERustmann Richard E · Willimantic, CTN3369FJ P Aero Holdings Inc · Carson City, NVN3369RFenton Flyers Inc · Hillsboro, MON3369SC-210 Lc · Atlantic, IAN3369TBauer Charles · Graceville, MNN3369WBlue Sky Aviation LLC · Attleboro, MAN3369XCollins Jerod William · Conifer, CON336AFLaine Carey E · Nevada City, CAN336APJsb Investments LLC · Morristown, TNN336BGBowling Green Flight Center LLC · Bowling Green, OHN336BWAllen Scott L · Ogallala, NEN336CABergeron Machine Shop Inc · Abbeville, LAN336CBBeechair LLC · Helena, MTN336DBGustafson Gary E · Motley, MNN336EDAdvanced Therapy Products Inc · Richmond, VAN336FSRobinson Charles M Sr · Niceville, FLN336HPChs Acquisitions Inc · Dallas, TXN336JALundquist Eric John Jr · Houston, TXN336LMKlm Unlimited Inc · Staples, MNN336MAHot Wings Aviation LLC · Fishers, INN336MCLewis University · Romeoville, ILN336MKNorth Star Aviation Inc · Mankato, MNN336MTNorth Peak Aviation LLC · Waunakee, WIN336NSky West Aviation Inc Trustee · Albuquerque, NMN336NANickravesh Niknam J · Saratoga, CAN336PAWingsleasing LLC · Wichita, KSN336PWCajan LLC · Kings Mountain, NCN336RABrown Donald B · Virginia Beach, VAN336RDByone Steve · Natchitoches, LAN336RVVose Kristin M · Bloomington, ILN336RWBe5816 LLC · Simi Valley, CAN336SQla Air LLC · Fort Myers, FLN336SBPieternelle J Coffy · Beaumont, TXN336SGAndrade South Florida Services Inc · Plantation, FLN336TTophatter85 LLC · Kirksville, MON336VRobertson Ryan T · Richmond, VAN336WTRomney Chad · Rigby, IDN336ZGoodman Michael R · New Brighton, PAN3370SWittenborn Grant A · Olathe, KSN3370UBriannas Wings Of Passion Foundation Inc · Magalia, CAN3370WRaddohl Garret L · New London, MNN3370YBrink Brittnie L · Baldwin, WIN33715Wdc Enterprises LLC · Beaumont, TXN3371EWings Over Texas Holdings LLC · Denton, TXN3371FRavens Rebuilders Inc · Ellenboro, WVN3371LAgresti Harold David · Ceres, CA
Back to AD 2007-04-19 R1