AD 2002-25-07
Registered aircraft · 542
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-25-07')
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-25-07')
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-25-07') 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-25-07') 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.
N5751MTrinkle Aviation LLC · Kingburg, CAN57LPPanther Helicopters Inc · Belle Chasse, LAN583MS & S 1165 Investments LLC · Austin, TXN5843Gm Leasing Co LLC · Broussard, LAN588AEAir Evac Ems Inc · O Fallon, MON588MAMercury Aviation Inc · Flowood, MSN589AEAir Evac Ems Inc · O'Fallon, MON595AEAir Evac Ems Inc · O Fallon, MON59AEAir Evac Ems Inc · O Fallon, MON59CHAir Center Helicopters Inc · Burleson, TXN5QYHeliinc LLC · Linden, NJN5WVState Of West Virginia · Charleston, WVN601GMNorth Wind Aviation LLC · Cottage Grove, ORN601SJAg Air Inc · Longmont, CON60TLIndustrial Helicopters LLC · Scott, LAN60VGFarwest Aviation LLC · Billings, MTN610TPCity Of Tampa Police Dept · Tampa, FLN6133CRedlands Heli Flight LLC · Redlands, CAN613LHTop Flight Aviation Of Mississippi LLC · Picayune, MSN6160YGm Leasing Co LLC · Broussard, LAN619Air Flite Inc · Shawnee, OKN61GRGalt Ranch Aviation LLC · Wht Sphr Spgs, MTN620LHNorth Wind Aviation LLC · Cottage Grove, ORN623QJb Air Services LLC · Brighton, CON626United States Department Of Interior · Boise, IDN629LSShook Farms LLC · Milan, MIN62HPTanana Leasing Inc · Fairbanks, AKN62TVHelicopters Inc · Cahokia, ILN630GJDavis George E · San Dimas, CAN6344DSummit Helicopters Inc · Salem, VAN63AEAir Evac Ems Inc · O Fallon, MON641HAHelicopter Applicators Inc · Gettysburg, PAN64AWN57aw LLC · Glendale, AZN64FCZma LLC · North Little Rock, ARN6501SInternational Air Services Inc Trustee · Carson City, NVN651HAHelicopter Applicators Inc · Gettysburg, PAN652HAHelicopter Applicators Inc · Gettysburg, PAN6533UTop Flight Aviation Of Mississippi LLC · Picayune, MSN657HAAgricultural Air Services LLC · Jupiter, FLN65RMRmc Aviation LLC · Klamath Falls, ORN6603XAerial Applicators Of Missouri LLC · Jonesboro, ARN660HAHelicopter Applicators Inc · Gettysburg, PAN6651HR & R Conner Aviation LLC · Conner, MTN66RRRiggs Rock Alan · Lake Mary, FLN67SJSan Juan Aviation LLC · Wilmington, DEN684AEAir Evac Ems Inc · O Fallon, MON68AEAir Evac Ems Inc · O Fallon, MON6NJNew Jersey State Police · West Trenton, NJN6QPHelicopters Inc · Cahokia, ILN6TYMooney Seven Inc · San Antonio, TX
Back to AD 2002-25-07