AD 95-09-13
Registered aircraft · 1,061
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:95-09-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:95-09-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:95-09-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:95-09-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.
N826CMKuriel Michael · Las Vegas, NVN82AWQualitair LLC Trustee · MichelstadtN82DAAircraft Holding Solutions LLC Trustee · Newark, DEN82GLJusticia Holdings LLC · Roanoke, VAN831BMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN834RMInfinity Properties LLC · Summerset, SDN8355Premier Plus Aviation Inc · Fort Pierce, FLN835RCDodson International Parts Inc · Rantoul, KSN8378GPrecision Guidance LLC · Bloomington, ILN83DLake Placid Flying Service Inc · Lake Placid, NYN83PBHyannis Air Service Inc DBA · Hyannis, MAN8401ACommercial Property Services Group LLC · Wichita, KSN842DYAltimate Transportaton Services LLC · Dallas, TXFirst renewal noticeN8430NFitch John A · Cary, ILN844CKTurpin Time LLC · Helena, MTN84DAVoorhees Investments Inc · Costa Mesa, CAN84PRSkov Equipment Co · Fabens, TXN850RMDueck Arthur P · Lakewood, OHN853MTK & T Inc · Salt Lake City, UTN855HSanford Larry D · Edmond, OKN859DMDavis Mark E · Pearland, TXN85KSCnet Aviation LLC · Lindale, TXN861HCN861hc LLC · Elk City, OKN866KABad Aire LLC · Aledo, TXN866PMBluview Management LLC · Avon Park, FLN86AWMohave County Sheriff'S Office · Kingman, AZN86PDTanric Aviation LLC · Tuscola, TXN870VLCaribbean Flyers LLC · San Juan, PRN871VLZee Enterprise Inc · Chicago, ILN87386Golden Eagle Flyers Inc · Cheyenne, WYN87541Chadbourne Daniel I Jr · Anchorage, AKN87561Forest Aire LLC · Flagstaff, AZN877JBOg Flights LLC · Dover, DEN8789BBearcat Aviation LLC · Joplin, MON878DMFly North 421 LLC · Helena, MTN87GKAlpha Zulu Aviation LLC · Spring, TXN87PPAerospace Trust Management LLC Trustee · Wilmington, DEN880JSDodson International Parts Inc · Rantoul, KSN8825GRichardson Dean A · St Thomas, VIFirst renewal noticeN884LPBecton Aviation LLC · Lubbock, TXN8851KJac Leasing LLC · Fort Myers, FLN88537Gink2 LLC · Elkhorn, NEN8853K8853k LLC · New Bedford, MAN88584Dallas Aero & Sales LLC · Poplar, MTN88604Trade Winds Aviation Holdings LLC · Lewes, DEN88606N88606 LLC · Ely, IAN88646Eagle Air LLC · Garden Ridge, TXN88PEFirst Winds LLC · Norfolk, NEN890CAHyannis Air Service Inc DBA · Hyannis, MAN89ADClairmont Holdings Vi LLC · St Thomas, VI
Back to AD 95-09-13