AD 2002-20-05
Registered aircraft · 2,705
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:2002-20-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-20-05')
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:2002-20-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-20-05') 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.
N149PDAdministracion De Los Servicios Generales · San Juan, PRN14HXHelicopter Express LLC · Chamblee, GAN14SJAlternative Energies Corp · Beaver Island, MIN14ZBlack Labs LLC · Anaconda, MTN150AMAir Methods LLC · Greenwood Village, CON150F11 11 Enterprises LLC · San German, PRN150HHCascade Airways LLC · Jefferson, ORN1510LCity Of Dallas · Dallas, TXN1511LCity Of Dallas · Dallas, TXN151WFQualitair LLC · MichelstadtN152AMAir Methods LLC · Greenwood Village, CON152CAChem Air LLC · Shreveport, LAN153PAGm Leasing Company LLC · Broussard, LAN155TVU S Helicopters Inc · Marshville, NCN156CAChem-Air LLC · Shreveport, LAN157PAPatriot Aviation Inc · Greenville, DEN157SJNorth Wind Aviation LLC · Cottage Grove, ORN158AMAir Methods LLC · Greenwood Village, CON158LHHelilease LLC · Lewes, DEN159AMAir Methods LLC · Greenwood Village, CON15FHD H Helicopter Inc DBA · Mascoutah, ILN15MXBank Of Utah Trustee · Salt Lake City, UTN15PSCb4 LLC · Wilmington, DEN160AMAir Methods LLC · Greenwood Village, CON160JAAg-Air Inc · Brent Alger, CAN1612Gm Leasing Co LLC · Broussard, LAN161ACHelipato Corp · Lake Worth, FLN161CGCsc Delaware Trust Co Trustee · Wilmington, DEN161SFGm Leasing Co LLC · Broussard, LAN162SHCastro Be LLC · Wilmington, DEN163RLRotorcraft Leasing Company LLC · Broussard, LAN164AETextron Financial Corp · Wichita, KSN164DMWcf Aerospace LLC · Madison, MSN164KMemphis Police Department · Memphis, TNN164RLRotorcraft Leasing Company LLC · Broussard, LAN165AETextron Financial Corp · Wichita, KSN165JKBohica Consulting Services Of Nevada Inc · Boulder City, NVN165SPSouthern Utah University · Cedar City, UTN16671Sarkinen Plumbing Inc · Portland, ORN166AETextron Financial Corp · Wichita, KSN166MSFlyone USA Corp · Miami, FLN16715Cahaba Forestry Services LLC · Flowood, MSN16726Aeroag Asset LLC · Edgerton, MON16760Riggs Bobby W · Lake Mary, FLN16770R & T Aviation LLC · Ethel, LAN16810Southern Helicopter Services Inc · Millington, TNN16832Orgis B J · Hallettsville, TXN168STMotor Heads Inc · Blairstown, NJN168TBSouthwest Aviation Enterprises · Haslet, TXN16929Reynolds Darryl G · Wills Point, TX
Back to AD 2002-20-05