AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N1903HEsp Aviation LLC · Mason City, IAN1903NFox Leonard A · Dubois, WYN1903SGriffin Products Inc · Wills Point, TXN1904HSpyropoulos Basil P · Lake Geneva, WIN1906HTriplett Gregory L · Holden, MON1906SMiskovic Dejan · San Jose, CAN1907JDaedal Flight LLC · Lancaster, SCN1908HSandlin James B · Surgoinsville, TNN19093Gedney Douglas Kevin · Issaquah, WAN1909SDennerline Rhett R · Northfield, ILN1909YDuncan Lori Ann · New Tazewell, TNN190AGCarson Ryan P · Albuquerque, NMN190AMMoghaddas Ali · Lake Sherwood, CAN190AVNghiem Daniel · Westminster, CAN190DCHillsboro Aero Academy LLC · Hillsboro, ORN190GESale Reported · Minden, NVSale reportedN190GTRincon Gabriel · Baton Rouge, LAN190HMn Helicopters Inc · Minneapolis, MNN190KASpencer William D · Martinsville, VAN190KTChupp Aaron A · Gallipolis, OHN190LPAmeriflyers Of Texas Inc · Addison, TXFirst renewal noticeN190MALightning Aviation LLC · Gillette, WYN190MEMenagerie Enterprises Inc DBA · Denison, TXN190PHJohnson Cameron M · Worthington, MNN190RROrr John C · Longmont, CON190RVMccormick David E · Antioch, ILN190SEAlbritton Randy L · Camas, WAN190TATuck Aerial Surveys Inc · Big Stone Gap, VAN190YSalo Mark W · Poulsbo, WAN19103Mashburn Paul M · Cumming, GAN1910YPeabody Riley A · Minnetonka, MNN19119Rose Randy J · Egg Harbor, WIN1911HAdair Aviation LLC · Mountain Home, ARN1911TSnp Aviation LLC · Avoca, IAN1911VLefort Charles J · Redding, CAN1911Y1911y Aviation LLC · Windsor, ILN1912PSojourner Field LLC · Kouts, INN1912THillman Motors Inc · Winter Haven, FLN1912YFrokjer Dean C · Saint Croix Falls, WIN1913TWilliams Ronald P · Woodway, TXN1913YSchmitt William Joseph · Santa Cruz, CAN1915TAeromx LLC · West Jefferson, OHN1915YJordan S Connor · Elizabeth City, NCN1916JCareer Track 2 LLC · Wilmington, DEN1916YLarsen Adam P · Gresham, ORN1917LEpiphany Airmotive LLC · Frisco, TXN1917YMock Joseph R · Huntsville, TXN1918LBurt Christopher James · Leesport, PAN1918TThompson Todd · Elmore, MNN19194Smokey Bear Air LLC · Cascade Locks, OR
Back to AD 2006-10-21