AD 2007-24-13
Registered aircraft · 4,026
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-24-13')
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-24-13')
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-24-13') 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-24-13') 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.
N2659BAnderson Brian E · York, PAN265JPN265jp LLC · Mill Valley, CAN265MBFlying Brick LLC · Monroe, NCN266KPN266kp LLC · Cincinnati, OHN266SRRf Aviation LLC · Eaton, CON267CPVanesian Bryan Dean · Apple Valley, CAN267PKRegistration Pending · Summerville, GARegistration pendingN268CDKahng Jim · Torrance, CAN268SRCirrus Design Corp · Duluth, MNN269JMPatterson Larry Jay · San Angelo, TXN26BZNorthcutt Chevrolet Buick LLC · Enid, OKN26DPColibri Ventures LLC · Dorado, PRN26MWMike Whiskey LLC · Atlanta, GAN26VSBoss Aviation LLC · Douglas, AZN26WRiddle Jay Allen · Gainesville, FLN26WMSportcruiser LLC · Wilmington, DEN2704SC&M Asset Management LLC · Owasso, OKN270ARDuffy Kevin · Manchester Center, VTN270MWM9 Aviation Ventures LLC · Philadelphia, PAN270WL270wl Aviation LLC · Owensboro, KYN2714CLipcon James P · Stow, MAN271NPJust Plane Stuff Inc · Jackson, MSN271SRGriffin James R · Pinedale, WYN272CDSegers Ernst E · Pensacola, FLN272DDelta Delta Aviation LLC · Pickerington, OHN272RHLewis Coleman · Dallas, TXN273DVD&K LLC · Sioux Falls, SDN273ESTailwinds Aviation LLC · Windham, NHN273NFTrk Management LLC · Punta Gorda, FLN273RVMev Aviation LLC · Fort Lauderdale, FLN274EFFour Forces Aviation LLC · Princeton, NJN274SRTn Sr22 LLC · Farragut, TNN275ABR2box LLC · Dover, DEN2763Valiair Lc Trustee · Casper, WYN276CDGandia Justin Kidd · Chicago, ILN276CPRothlisberger Ben · Farmington, MON276GEMaricorp U S LLC · Shell Knob, MON277JDMeadows Construction Corp · Fort Smith, ARN277RRossignoli Holdings LLC · Atlanta, GAN278CDCirrus Aviators LLC · Elm Grove, WIN278GZNichols Industrial Construction Co Inc · Birmingham, ALN278JAAerownership North American Services Inc Trustee · Wilmington, DEN278SREllsworth Farm LLC · Kingsbury, NYN278WDSnk LLC · Reisterstown, MDN279CPBarnard Henry H III · Albany, GAN279MTGmcm Aviation LLC · Central, SCN27EMStair Colin · Brookfield, WIN27FDCirrus Design Corp · Duluth, MNN27LGStilda One LLC · Fort Loramie, OHN27PFNorthstar Global Flight LLC · Bronxville, NY
Back to AD 2007-24-13