AD 2005-01-18
Registered aircraft · 1,714
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:2005-01-18')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-01-18')
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:2005-01-18') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-01-18') 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.
N121LBEastern Stearman Inc Trustee · Leesburg, VAN1221FTj Air Holdings Inc Trustee · Wilmington, DEN122BKFlying Mixers LLC · Amarillo, TXN122RGRiversville Aircraft Corp · Belgrade Lakes, MEN123HGHorowitz Transportation LLC · Newport Beach, CAN123MLNfbn LLC · Scottsdale, AZN123RFLucky Air LLC · Hobbs, NMN124CMSolomon Mark Trustee · Wilmington, DEN124EBPremium Air LLC · Hibbing, MNN124GADriscoll Health Care Services · Corpus Christi, TXN124KTGams Air LLC · Doral, FLN124WRH.A.I. Services Inc · Justin, TXN1253VBane Patricia L · Midland, TXN1253WWorthington Enterprises Inc · Columbus, OHN125BKColoramo Federal Credit Union · Grand Junction, CON125KAAirmax LLC · Lancaster, SCN125KSAlpine Aviation Inc · Provo, UTN125TECj Brown Express LLC · Graettinger, IAN125TSDouble J Aviation Inc · Klamath Falls, ORN126JHM&P Aviation LLC · Lakeland, TNN126MCSkyline Aviation Services LLC · Miramar, FLN127GABeech Transportation Inc · Eden Prairie, MNN127TACompany Wrench Ltd · Carroll, OHN128ASParker Robert E · Corpus Christi, TXN128JDepartment Of Homeland Security · Washington, DCN128VTState Of Missouri · Jefferson City, MON12NGNorthrop Grumman Systems Corp · El Segundo, CAN130BDBank Of Utah Trustee · Salt Lake City, UTN130RLOscar Charlie II LLC · California, MDN131KGKa131kg LLC · Knoxville, TNN131SJGravitas Aviation LLC · Dallas, TXN132NFlying Cowboys LLC · Merced, CAN133GAJab Aire LLC · Wilmington, DEN1344LU S Army · Redstone Arsenal, ALN1346KU S Army · Redstone Arsenal, ALN1349KU S Army · Redstone Arsenal, ALN1351KU S Army · Redstone Arsenal, ALN1357KTextron Aviation Inc · Wichita, KSN135MKRio Frio Leasing Co LLC · Houston, TXN135SSTextron Aviation Inc · Wichita, KSN136KFFisher Auto Parts Inc · Staunton, VAN137FLCharlie-001 LLC · Sugar Grove, ILN138MMTextron Aviation Inc · Wichita, KSN139RRRyan Renae L Trustee · Wichita, KSN140MCPlane To Sea LLC · Raleigh, NCN140MNTextron Aviation Inc · Wichita, KSN140RLN140rl LLC · Kalispell, MTN141LVictor One Four One LLC · Boston, MAN141SMInfinity Aeronautics LLC · Greer, SCN141SULynch Family Companies Inc · Waucoma, IA
Back to AD 2005-01-18