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.
N1214Henderson Joseph · Camargo, ILN1214TPost 8 Flight Opps Inc · Topeka, KSN1214XCouch Troy L · Westcliffe, CON1215JRinggold Rolf E · Circle Pines, MNN1215LMagrini Shawn P · Salem, OHN1215XCella Joseph · Sewell, NJN1216LLynch Steven J · Harrisville, RIN1216TOlsen Christopher D · Bothell, WAN1217EJohnston Jason · Chugiak, AKN1217PHarrison Jeffrey · Benton, ARN1217TSauer Roger A · Glenburn, NDN1217XRanger Aviation Enterprises Inc · San Angelo, TXN1218EShibakov Alexander Y · Gainesboro, TNN1218JWeeks Wesley J · Iowa Park, TXN1218SSkyvibe Leasing LLC · Aurora, ORN1218WOndrick Aviation LLC · Chicopee, MAN1218XSmith II Richard D · Luthersville, GAN1219TLrh Equipment LLC · Pendleton, ORN121AWhidby Richard L · Aynor, SCN121AHSoul Shine LLC · Nashville, TNN121ARGold Mountain LLC · Kalispell, MTN121AVPreece William F · Cheshire, CTN121CJCharlie Juliet Aerospace LLC · Naugatuck, CTN121CPCivil Air Patrol · Maxwell Afb, ALN121CWAerostar Training Services LLC · Kissimmee, FLN121DBTexins Flying Club · Mckinney, TXN121DSGarvison Paul L · Hillsville, VAN121DWFlight World Inc · San Juan, PRN121EConger Martin D · Pasco, WAN121GHSunset Aviation LLC · Huntington, INN121GKBook Thomas D · Loveland, CON121GRSimmons Scott J · Palm Springs, CAN121HEJarrett Air LLC · Ashland City, TNN121HHTimm Robert S · Minneapolis, MNN121HSCharles Dan H · Des Allemands, LAN121JCNewsom William A · Cheraw, SCN121JLPlane Fun Inc Tr Trustee · Snellville, GAN121LMGolden Age N121lm LLC · Des Moines, IAN121LTDream 10 LLC · Dunnellon, FLN121PRPaulich John III · Naples, FLN121RFRafamedia LLC · Stamford, CTN121RLZaytsev Petr · Pflugerville, TXN121SClark William H IV · Thurmont, MDN121SESpitzer Helicopter LLC · Woodland Hills, CAN121SGTaliaferro Leigh · Abilene, TXN121SLLadet David E · Lavonia, GAN121SPFl280 LLC · Deland, FLN121SXRegistered aircraftN121TDelmarva Flight Leasing Inc · East Moriches, NYN121TCDonney Tom J · Sturgis, SD
Back to AD 2006-10-21