AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N342GLast Dean H · Mill Creek, WAN342HTrautman Michael · Hamilton, MTN342JBCentral Ohio Flyers Association · Columbus, OHN342LSAutorotation Aviation LLC · Ardmore, OKN342MAStauffer Michael S · Wichita Falls, TXN342MCCarra Michael J · Aiken, SCN342MDCunningham Thomas J · New Braunfels, TXN342MEAerostatics LLC · Gainesville, FLN342MJRohweder Alfredo R · Pompano Beach, FLN342MKNorth Star Aviation Inc · Mankato, MNN342MLOrlowski Michael A · Gold Hill, NCN342MMJohnson Aaron M · San Ramon, CAN342MWHolway Stephen M · Gainesville, FLN342RAHeartland Aviation LLC · Harrisonville, MON342SHorn Travis L · Clarksville, ARN342TAUnited States Air Force 60 Fss/Fsca · Rio Vista, CAN342TTLewis Charles Ryan · Napa, CAN342UWelch Robert T · Alamogordo, NMN342WPPapa LLC · Eufaula, ALN342ZBaus Jordan M · Seattle, WAN34302Romero John M · College Station, TXN34308Greenwood Kevin · Tucson, AZN3430FWingeier Dairy Farms · Alto, MIN3430LDachniwsky Holdings LLC · Southlake, TXN3430NKellner Darlene D · Lancaster, PAN3430PChamberlain Paul E · Troup, TXN3430SBlue Skai Aviators LLC · Lawton, OKN3430TMeador Phillips H · Lexington, KYN3430WHerring Taylor R · Laredo, TXN34316Dane Ward LLC · Rising Fawn, GAN3431LJacobs Brittany Lyn · Seattle, WAN3431RGuibaud Albert G · Monrovia, CAN3431YMinor Joseph H · Hyannis, NEN34320Eagle Sky Patrol Inc · Deadwood, SDN34328Hamilton Thomas Arden · Lovettsville, VAN3432FBierschwale Land Co LLC · Mason, TXN3432KPorte Elvis · Miami, FLN3432MSears Megan · Rigby, IDN3432WNunak Air Taxi LLC · Kenai, AKN3433FVapor-Mist Sanitizing Systems · Boca Raton, FLN3433PBolgar Mark S · Ewing, NJN3433RAlty It Solutions LLC · Milan, MIN3433SKah Gretchen Wendel · San Francisco, CAN3433XRundus Timothy A · Chandler, AZN3433ZKitchen Ronald L · Leasburg, MOFirst renewal noticeN34343Wright Wayne M · Chestertown, MDN34346Ball Donald · Hatfield, PAN34348Pingree Properties LLC · Hampshire, ILN3434FCoile Brantley · Athens, GAN3434PNasair LLC · Flower Mound, TX
Back to AD 2007-04-19 R1